DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on PO_REQUISITION_HEADERS_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'