DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on PO_REQUISITION_HEADERS_ALL

Line 1883: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,

1879: NULL AS secondary_uom_code,
1880: MIN(prd.project_id) AS project_id,
1881: MIN(prd.task_id) AS task_id,
1882: NULL AS lpn_id
1883: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,
1884: rcv_shipment_lines rsl, rcv_shipment_headers rsh, po_req_distributions_all prd,
1885: mtl_units_of_measure muom
1886: WHERE prh.requisition_header_id = prl.requisition_header_id
1887: AND prd.requisition_line_id = prl.requisition_line_id

Line 1926: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,

1922: NULL AS secondary_uom_code,
1923: MIN(prd.project_id) AS project_id,
1924: MIN(prd.task_id) AS task_id,
1925: NULL AS lpn_id
1926: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,
1927: po_req_distributions_all prd, mtl_interorg_parameters mip, mtl_units_of_measure muom
1928: WHERE prh.requisition_header_id = prl.requisition_header_id
1929: AND prd.requisition_line_id = prl.requisition_line_id
1930: AND prh.authorization_status = 'APPROVED'