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 273: FROM po_headers_all POH, hr_operating_units HOU

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

Line 598: po_headers_all POH

594: INTO l_txn_price
595: FROM rcv_transactions RT,
596: po_distributions_all POD,
597: po_line_locations_all PLL,
598: po_headers_all POH
599: WHERE RT.transaction_id = rec_txn.transaction_id
600: AND POD.po_distribution_id = RT.po_distribution_id
601: AND PLL.line_location_id = RT.po_line_location_id
602: AND POH.po_header_id = RT.po_header_id;

Line 644: po_headers_all POH

640: (RT.source_doc_quantity/RT.primary_quantity)))
641: INTO l_txn_price
642: FROM rcv_transactions RT,
643: po_line_locations_all PLL,
644: po_headers_all POH
645: WHERE RT.transaction_id = rec_txn.transaction_id
646: AND PLL.line_location_id = RT.po_line_location_id
647: AND POH.po_header_id = RT.po_header_id;
648:

Line 895: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS

891: -- Pre-reqs :
892: -- Parameters :
893: -- p_purge_entity_type IN VARCHAR2
894: -- The table of which the entity is the primary identifier
895: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS
896: -- p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype
897: -- Contains the List of PO_HEADER_ID's to be evaluated
898: -- x_purge_out_rec OUT NOCOPY RCV_AccrualUtilities_GRP.purge_out_rectype
899: -- Contains c character ('Y'/'N') indicating whether records

Line 989: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS

985: -- Pre-reqs :
986: -- Parameters :
987: -- p_purge_entity_type IN VARCHAR2
988: -- The table of which the entity is the primary identifier
989: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS
990: -- p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype
991: -- Contains the List of PO_HEADER_ID's for which corresponding
992: -- records need to be deleted from RAE and RRS
993: ----------------------------------------------------------------------------------------------