DBA Data[Home] [Help]

APPS.PO_AME_SETUP_PVT dependencies on PO_LINES_MERGE_V

Line 729: from po_lines_merge_v plm,

725:
726: BEGIN
727: select nvl(SUM(decode(plm.order_type_lookup_code, 'RATE', plm.amount, 'FIXED PRICE', plm.amount, plm.quantity * plm.unit_price)), 0)
728: into l_changed_amount
729: from po_lines_merge_v plm,
730: po_headers_merge_v phm
731: where plm.po_header_id = phm.po_header_id
732: and phm.draft_id = plm.draft_id
733: and phm.ame_approval_id = ameApprovalId;