APPS.RCV_ACCRUALUTILITIES_GRP dependencies on PO_HEADERS_ALL

Line 176: l_po_org_id PO_HEADERS_ALL.org_id%TYPE;

172: l_source_doc_code RCV_TRANSACTIONS.SOURCE_DOCUMENT_CODE%TYPE;
173:
174: l_rcv_organization_id RCV_TRANSACTIONS.organization_id%TYPE;
175: l_po_header_id RCV_TRANSACTIONS.po_header_id%TYPE;
176: l_po_org_id PO_HEADERS_ALL.org_id%TYPE;
177: l_po_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;
178: l_rcv_org_id CST_ORGANIZATION_DEFINITIONS.operating_unit%TYPE;
179: l_rcv_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;
180: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;

Line 270: FROM po_headers_all POH, hr_operating_units HOU

266: /* Get PO Operating Unit and Set of Books */
267: l_stmt_num := 20;
268: SELECT POH.org_id, HOU.set_of_books_id
269: INTO l_po_org_id, l_po_sob_id
270: FROM po_headers_all POH, hr_operating_units HOU
271: WHERE POH.org_id = HOU.organization_id
272: AND POH.po_header_id = l_po_header_id;
273:
274: IF l_sLog THEN

Line 496: po_headers_all POH

492: INTO l_txn_price
493: FROM rcv_transactions RT,
494: po_distributions_all POD,
495: po_line_locations_all PLL,
496: po_headers_all POH
497: WHERE RT.transaction_id = rec_txn.transaction_id
498: AND POD.po_distribution_id = RT.po_distribution_id
499: AND PLL.line_location_id = RT.po_line_location_id
500: AND POH.po_header_id = RT.po_header_id;

Line 542: po_headers_all POH

538: (RT.source_doc_quantity/RT.primary_quantity)))
539: INTO l_txn_price
540: FROM rcv_transactions RT,
541: po_line_locations_all PLL,
542: po_headers_all POH
543: WHERE RT.transaction_id = rec_txn.transaction_id
544: AND PLL.line_location_id = RT.po_line_location_id
545: AND POH.po_header_id = RT.po_header_id;
546:

Line 790: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS

786: -- Pre-reqs :
787: -- Parameters :
788: -- p_purge_entity_type IN VARCHAR2
789: -- The table of which the entity is the primary identifier
790: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS
791: -- p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype
792: -- Contains the List of PO_HEADER_ID's to be evaluated
793: -- x_purge_out_rec OUT NOCOPY RCV_AccrualUtilities_GRP.purge_out_rectype
794: -- Contains c character ('Y'/'N') indicating whether records

Line 884: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS

880: -- Pre-reqs :
881: -- Parameters :
882: -- p_purge_entity_type IN VARCHAR2
883: -- The table of which the entity is the primary identifier
884: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS
885: -- p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype
886: -- Contains the List of PO_HEADER_ID's for which corresponding
887: -- records need to be deleted from RAE and RRS
888: ----------------------------------------------------------------------------------------------