APPS.WMS_XDOCK_PEGGING_PUB dependencies on PO_REQ_DISTRIBUTIONS_ALL

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

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

Line 1927: po_req_distributions_all prd, mtl_interorg_parameters mip, mtl_units_of_measure muom

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

Line 2270: FROM po_req_distributions_all

2266: CURSOR lock_intreq_record(p_uom_code VARCHAR2, p_project_id NUMBER, p_task_id NUMBER) IS
2267: SELECT muom_prl.uom_code, prd.project_id, prd.task_id
2268: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl, mtl_units_of_measure muom_prl,
2269: (SELECT requisition_line_id, MIN(project_id) AS project_id, MIN(task_id) AS task_id
2270: FROM po_req_distributions_all
2271: WHERE requisition_line_id = l_supply_line_id
2272: GROUP BY requisition_line_id
2273: HAVING COUNT(DISTINCT NVL(project_id, -999)) = 1
2274: AND COUNT(DISTINCT NVL(task_id, -999)) = 1