APPS.RCV_ACCRUALUTILITIES_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 181: l_lcm_flag PO_LINE_LOCATIONS_ALL.lcm_flag%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;
181: l_lcm_flag PO_LINE_LOCATIONS_ALL.lcm_flag%TYPE;
182:
183: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
184: l_module constant varchar2(60) := 'po.plsql.'||l_full_name;
185:

Line 253: po_line_locations_all poll

249: nvl(poll.lcm_flag,'N')
250: INTO l_source_doc_code, l_po_header_id, l_rcv_organization_id,
251: l_lcm_flag
252: FROM rcv_transactions rt,
253: po_line_locations_all poll
254: WHERE rt.transaction_id = p_rcv_transaction_id
255: AND rt.po_line_location_id = poll.line_location_id;
256:
257: IF l_source_doc_code <> 'PO' THEN

Line 597: po_line_locations_all PLL,

593: (RT.source_doc_quantity/RT.primary_quantity)))
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

Line 618: po_line_locations_all pol,

614: INTO
615: l_tax
616: from
617: po_distributions_all pod,
618: po_line_locations_all pol,
619: rcv_transactions rt
620: where
621: rt.transaction_id = rec_txn.transaction_id
622: and rt.po_line_location_id = pol.line_location_id

Line 643: po_line_locations_all PLL,

639: 'P',NVL(POH.rate, 1)) *
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;