APPS.WMS_XDOCK_PEGGING_PUB dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1859: rcv_shipment_lines rsl, rcv_shipment_headers rsh, po_req_distributions_all prd,

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
1863: AND prh.authorization_status = 'APPROVED'

Line 1902: po_req_distributions_all prd, mtl_interorg_parameters mip, mtl_units_of_measure muom

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'
1906: AND NVL(prl.cancel_flag,'N') = 'N'

Line 2245: FROM po_req_distributions_all

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
2248: HAVING COUNT(DISTINCT NVL(project_id, -999)) = 1
2249: AND COUNT(DISTINCT NVL(task_id, -999)) = 1