APPS.RCV_ROI_TRANSACTION dependencies on PO_LINES_ALL

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

2781: /***** Bug # 1553154
2782: ***** There was a performance issue since the cursor COUNT_DISTRIBUTIONS
2783: ***** was driving through PO_LINE_LOCATIONS_ALL. Modified the Select
2784: ***** statement so that it will drive through PO_HEADERS_ALL
2785: ***** followed by PO_LINES_ALL which is followed by PO_LINE_LOCATIONS_ALL
2786: ***** so that there is an improvement in performance.
2787: *****/
2788: CURSOR distributions(
2789: header_id NUMBER,

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

2864: /***** Bug # 1553154
2865: ***** There was a performance issue since the cursor DISTRIBUTIONS
2866: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL
2867: ***** Modified the Select statement so that it will drive through
2868: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by
2869: ***** PO_LINE_LOCATIONS_ALL which in turn is followed by
2870: ***** PO_DISTRIBUTIONS_ALL so that there is an improvement in
2871: ***** Performance
2872: *****/

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

6846: item_revision_record rcv_shipment_line_sv.item_id_record_type;
6847: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
6848: item_id_record rcv_shipment_line_sv.item_id_record_type;
6849: l_asn_sub_item_txn varchar2(1); --Bug: 5598511
6850: l_pol_item_id po_lines_all.item_id%type; --Bug: 5598511
6851: BEGIN
6852: -- validate item id
6853: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
6854: RETURN;

Line 10348: from po_lines_all

10344: where po_header_id = x_po_transferrec.po_head_id;
10345:
10346: select line_num
10347: into l_po_line_num
10348: from po_lines_all
10349: where po_line_id = x_po_transferrec.po_line_id;
10350:
10351: select shipment_num
10352: into l_po_line_loc_num

Line 15455: po_lines_all pl

15451: INTO x_cascaded_table(n).value_basis,
15452: x_cascaded_table(n).matching_basis,
15453: x_cascaded_table(n).purchase_basis
15454: FROM po_line_locations_all pll,
15455: po_lines_all pl
15456: WHERE pl.po_line_id = x_cascaded_table(n).po_line_id
15457: and pl.po_line_id = pll.po_line_id
15458: and pll.line_location_id =x_cascaded_table(n).po_line_location_id;
15459: exception

Line 15498: po_lines_all pl

15494: INTO x_cascaded_table(n).value_basis,
15495: x_cascaded_table(n).matching_basis,
15496: x_cascaded_table(n).purchase_basis
15497: FROM po_line_locations_all pll,
15498: po_lines_all pl
15499: WHERE pl.po_line_id = x_cascaded_table(n).po_line_id
15500: and pl.po_line_id = pll.po_line_id
15501: and pll.shipment_num =
15502: x_cascaded_table(n).document_shipment_line_num;

Line 15550: FROM po_lines_all

15546: NVL(matching_basis, 'QUANTITY')
15547: INTO x_cascaded_table(n).value_basis,
15548: x_cascaded_table(n).purchase_basis,
15549: x_cascaded_table(n).matching_basis
15550: FROM po_lines_all
15551: WHERE po_line_id = x_cascaded_table(n).po_line_id;
15552: exception
15553: when no_data_found then
15554: IF (g_asn_debug = 'Y') THEN