APPS.RCV_ROI_TRANSACTION dependencies on PO_LINES_ALL

Line 3269: ***** followed by PO_LINES_ALL which is followed by PO_LINE_LOCATIONS_ALL

3265: /***** Bug # 1553154
3266: ***** There was a performance issue since the cursor COUNT_DISTRIBUTIONS
3267: ***** was driving through PO_LINE_LOCATIONS_ALL. Modified the Select
3268: ***** statement so that it will drive through PO_HEADERS_ALL
3269: ***** followed by PO_LINES_ALL which is followed by PO_LINE_LOCATIONS_ALL
3270: ***** so that there is an improvement in performance.
3271: *****/
3272: CURSOR distributions(
3273: header_id NUMBER,

Line 3354: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by

3350: /***** Bug # 1553154
3351: ***** There was a performance issue since the cursor DISTRIBUTIONS
3352: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL
3353: ***** Modified the Select statement so that it will drive through
3354: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by
3355: ***** PO_LINE_LOCATIONS_ALL which in turn is followed by
3356: ***** PO_DISTRIBUTIONS_ALL so that there is an improvement in
3357: ***** Performance
3358: *****/

Line 7603: l_pol_item_id po_lines_all.item_id%type; --Bug: 5598511

7599: item_revision_record rcv_shipment_line_sv.item_id_record_type;
7600: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
7601: item_id_record rcv_shipment_line_sv.item_id_record_type;
7602: l_asn_sub_item_txn varchar2(1); --Bug: 5598511
7603: l_pol_item_id po_lines_all.item_id%type; --Bug: 5598511
7604: BEGIN
7605: -- validate item id
7606: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
7607: RETURN;

Line 11411: from po_lines_all

11407: where po_header_id = x_po_transferrec.po_head_id;
11408:
11409: select line_num
11410: into l_po_line_num
11411: from po_lines_all
11412: where po_line_id = x_po_transferrec.po_line_id;
11413:
11414: select shipment_num
11415: into l_po_line_loc_num

Line 16874: po_lines_all pl

16870: INTO x_cascaded_table(n).value_basis,
16871: x_cascaded_table(n).matching_basis,
16872: x_cascaded_table(n).purchase_basis
16873: FROM po_line_locations_all pll,
16874: po_lines_all pl
16875: WHERE pl.po_line_id = x_cascaded_table(n).po_line_id
16876: and pl.po_line_id = pll.po_line_id
16877: and pll.line_location_id =x_cascaded_table(n).po_line_location_id;
16878: exception

Line 16917: po_lines_all pl

16913: INTO x_cascaded_table(n).value_basis,
16914: x_cascaded_table(n).matching_basis,
16915: x_cascaded_table(n).purchase_basis
16916: FROM po_line_locations_all pll,
16917: po_lines_all pl
16918: WHERE pl.po_line_id = x_cascaded_table(n).po_line_id
16919: and pl.po_line_id = pll.po_line_id
16920: and pll.shipment_num =
16921: x_cascaded_table(n).document_shipment_line_num;

Line 16969: FROM po_lines_all

16965: NVL(matching_basis, 'QUANTITY')
16966: INTO x_cascaded_table(n).value_basis,
16967: x_cascaded_table(n).purchase_basis,
16968: x_cascaded_table(n).matching_basis
16969: FROM po_lines_all
16970: WHERE po_line_id = x_cascaded_table(n).po_line_id;
16971: exception
16972: when no_data_found then
16973: IF (g_asn_debug = 'Y') THEN