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 2564: FROM po_line_locations_all

2560: * for use in all transaction types*/
2561: BEGIN
2562: SELECT drop_ship_flag
2563: INTO x_drop_ship_flag
2564: FROM po_line_locations_all
2565: WHERE line_location_id = x_cascaded_table(n).po_line_location_id;
2566: -- if no data found, do nothing
2567: EXCEPTION
2568: WHEN NO_DATA_FOUND THEN

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

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

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

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

Line 10353: from po_line_locations_all

10349: where po_line_id = x_po_transferrec.po_line_id;
10350:
10351: select shipment_num
10352: into l_po_line_loc_num
10353: from po_line_locations_all
10354: where line_location_id = x_po_transferrec.po_line_location_id;
10355:
10356: select distribution_num
10357: into l_po_dist_num

Line 15454: FROM po_line_locations_all pll,

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

Line 15497: FROM po_line_locations_all pll,

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

Line 15998: WHERE org_id = (SELECT org_id FROM po_line_locations_all

15994:
15995: SELECT set_of_books_id
15996: into v_sobid
15997: FROM financials_system_params_all
15998: WHERE org_id = (SELECT org_id FROM po_line_locations_all
15999: WHERE line_location_id = x_cascaded_table(n).po_line_location_id);
16000:
16001: l_rate := gl_currency_api.get_rate(v_sobid, l_po_currency, l_lcm_date, l_po_rate_type);
16002: