DBA Data[Home] [Help]

APPS.PO_AME_SETUP_PVT dependencies on PO_LINES_ALL

Line 718: from po_lines_all plm, po_headers_merge_v phm

714: BEGIN
715: BEGIN
716: select nvl(SUM(decode(plm.order_type_lookup_code, 'RATE', plm.amount, 'FIXED PRICE', plm.amount, plm.quantity * plm.unit_price)), 0)
717: into l_original_amount
718: from po_lines_all plm, po_headers_merge_v phm
719: where plm.po_header_id = phm.po_header_id
720: and phm.ame_approval_id = ameApprovalId;
721: EXCEPTION
722: WHEN no_data_found THEN

Line 782: from po_lines_draft_all pld, po_lines_all pl

778: ABS((decode(pld.order_type_lookup_code, 'RATE', pld.amount, 'FIXED PRICE', pld.amount, pld.quantity * pld.unit_price)) -
779: NVL((decode(pl.order_type_lookup_code, 'RATE', pl.amount, 'FIXED PRICE', pl.amount, pl.quantity * pl.unit_price)), 0) )
780: ), 0)
781: into l_changed_amount
782: from po_lines_draft_all pld, po_lines_all pl
783: where pld.po_header_id = p_po_header_id
784: and pld.draft_id = p_draft_id
785: and pl.po_line_id(+) = pld.po_line_id;
786: