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.WMS_XDOCK_PEGGING_PUB dependencies on PO_REQUISITION_LINES_ALL

Line 1858: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,

1854: NULL AS secondary_uom_code,
1855: MIN(prd.project_id) AS project_id,
1856: MIN(prd.task_id) AS task_id,
1857: NULL AS lpn_id
1858: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,
1859: rcv_shipment_lines rsl, rcv_shipment_headers rsh, po_req_distributions_all prd,
1860: mtl_units_of_measure muom
1861: WHERE prh.requisition_header_id = prl.requisition_header_id
1862: AND prd.requisition_line_id = prl.requisition_line_id

Line 1901: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,

1897: NULL AS secondary_uom_code,
1898: MIN(prd.project_id) AS project_id,
1899: MIN(prd.task_id) AS task_id,
1900: NULL AS lpn_id
1901: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,
1902: po_req_distributions_all prd, mtl_interorg_parameters mip, mtl_units_of_measure muom
1903: WHERE prh.requisition_header_id = prl.requisition_header_id
1904: AND prd.requisition_line_id = prl.requisition_line_id
1905: AND prh.authorization_status = 'APPROVED'

Line 2243: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl, mtl_units_of_measure muom_prl,

2239: -- For UOM integrity, if we want to match the UOM from the supply to the reservation,
2240: -- just use the UOM at the requisition line level.
2241: CURSOR lock_intreq_record(p_uom_code VARCHAR2, p_project_id NUMBER, p_task_id NUMBER) IS
2242: SELECT muom_prl.uom_code, prd.project_id, prd.task_id
2243: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl, mtl_units_of_measure muom_prl,
2244: (SELECT requisition_line_id, MIN(project_id) AS project_id, MIN(task_id) AS task_id
2245: FROM po_req_distributions_all
2246: WHERE requisition_line_id = l_supply_line_id
2247: GROUP BY requisition_line_id

Line 9879: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl, rcv_shipment_headers rsh,

9875: wcs_prl.carrier_id))))) AS carrier_id,
9876: NVL(wts.planned_arrival_date,
9877: NVL(NVL(rsh.expected_receipt_date, rsh.shipped_date),
9878: prl.need_by_date)) AS expected_receipt_date
9879: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl, rcv_shipment_headers rsh,
9880: oe_order_lines_all ool, wsh_delivery_details wdd,
9881: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9882: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9883: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool,