Wednesday 13 July 2011

PO AND PR QUANTITY & PRICE NOT INCREAS - personalization

QUANTITY

TRIGGER = WHEN-VALIDATE-RECORD
 TRIGGER_EVENT  = PO_LINES


CONDITION = :PO_LINES.QUANTITY>(select prl.QUANTITY
from po_requisition_lines_all prl,
po_req_distributions_all prd
where prl.REQUISITION_line_ID = prd.REQUISITION_LINE_ID
and prd.DISTRIBUTION_ID in (select REQ_DISTRIBUTION_ID from po_distributions_all
where po_line_id = :po_lines.po_line_id))

MESSAGE = ERROR


UNIT PRICE

TRIGGER = WHEN-VALIDATE-RECORD
 TRIGGER_EVENT  = PO_LINES


:PO_LINES.UNIT_PRICE>(select prl.UNIT_PRICE
from po_requisition_lines_all prl,
po_req_distributions_all prd
where prl.REQUISITION_line_ID = prd.REQUISITION_LINE_ID
and prd.DISTRIBUTION_ID in (select REQ_DISTRIBUTION_ID from po_distributions_all
where po_line_id = :po_lines.po_line_id))

No comments:

Post a Comment