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 250: po_line_locations_all poll

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

Line 495: po_line_locations_all PLL,

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

Line 516: po_line_locations_all pol,

512: INTO
513: l_tax
514: from
515: po_distributions_all pod,
516: po_line_locations_all pol,
517: rcv_transactions rt
518: where
519: rt.transaction_id = rec_txn.transaction_id
520: and rt.po_line_location_id = pol.line_location_id

Line 541: po_line_locations_all PLL,

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