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_AVAILABILITY dependencies on PO_LINE_LOCATIONS_ALL

Line 192: FROM po_line_locations_all pll,

188: SELECT SUM(pod.quantity_ordered) quantity,
189: pol.item_id,
190: pol.unit_meas_lookup_code unit_of_measure,
191: null primary_unit_of_measure
192: FROM po_line_locations_all pll,
193: po_lines_all pol,
194: po_distributions_all pod
195: WHERE pll.line_location_id = p_supply_demand_line_id
196: AND pll.po_line_id = pol.po_line_id

Line 211: FROM po_line_locations_all pll,

207: SELECT SUM(pod.quantity_ordered) quantity,
208: pol.item_id,
209: pol.unit_meas_lookup_code unit_of_measure,
210: si.primary_unit_of_measure primary_unit_of_measure
211: FROM po_line_locations_all pll,
212: po_lines_all pol,
213: po_distributions_all pod,
214: mtl_system_items si
215: WHERE pll.line_location_id = p_supply_demand_line_id

Line 1069: FROM po_line_locations_all pll,

1065: * Change all the table to base tables.
1066: */
1067: SELECT 'Y'
1068: INTO x_valid_status
1069: FROM po_line_locations_all pll,
1070: po_lines_all pol,
1071: po_headers_all poh
1072: WHERE pol.po_header_id = poh.po_header_id
1073: AND pll.po_line_id = pol.po_line_id