eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ROI_TRANSACTION dependencies on PO_LINE_LOCATIONS_ALL

Line 3046: FROM po_line_locations_all

3042: * for use in all transaction types*/
3043: BEGIN
3044: SELECT drop_ship_flag
3045: INTO x_drop_ship_flag
3046: FROM po_line_locations_all
3047: WHERE line_location_id = x_cascaded_table(n).po_line_location_id;
3048: -- if no data found, do nothing
3049: EXCEPTION
3050: WHEN NO_DATA_FOUND THEN

Line 3267: ***** was driving through PO_LINE_LOCATIONS_ALL. Modified the Select

3263: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'));
3264:
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: *****/

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 3355: ***** PO_LINE_LOCATIONS_ALL which in turn is followed by

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: *****/
3359: CURSOR count_distributions(

Line 11416: from po_line_locations_all

11412: where po_line_id = x_po_transferrec.po_line_id;
11413:
11414: select shipment_num
11415: into l_po_line_loc_num
11416: from po_line_locations_all
11417: where line_location_id = x_po_transferrec.po_line_location_id;
11418:
11419: select distribution_num
11420: into l_po_dist_num

Line 16873: FROM po_line_locations_all pll,

16869: NVL(pl.purchase_basis,'GOODS')
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;

Line 16916: FROM po_line_locations_all pll,

16912: NVL(pl.purchase_basis,'GOODS')
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 =