DBA Data[Home] [Help]

APPS.CSE_PO_RECEIPT_INTO_PROJECT dependencies on PO_HEADERS_ALL

Line 581: po_headers_all pha

577: FROM rcv_transactions rt,
578: po_distributions_all pda,
579: po_line_locations_all plla,
580: po_lines_all pla,
581: po_headers_all pha
582: WHERE rt.transaction_id = p_rcv_txn_id
583: AND rt.po_distribution_id = pda.po_distribution_id
584: AND rt.po_line_location_id = plla.line_location_id
585: AND rt.po_line_id = pla.po_line_id

Line 791: FROM po_vendors pv, po_headers_all ph

787: AND pt.project_id = p_project_id;
788:
789: CURSOR vendor_cur(p_po_header_id IN number) IS
790: SELECT pv.vendor_id, pv.segment1
791: FROM po_vendors pv, po_headers_all ph
792: WHERE ph.po_header_id = p_po_header_id
793: AND pv.vendor_id = ph.vendor_id;
794:
795: CURSOR Exp_Details_Cur(P_PO_Distribution_ID IN NUMBER) IS