DBA Data[Home] [Help]

APPS.GML_MOBILE_RECEIPT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 2825: rcv_shipment_lines rsl , po_req_distributions_all prd

2821: WHERE organization_id = p_Organization_Id
2822: and concatenated_segments like p_concatenated_segments
2823: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2824: and exists (SELECT 1 FROM po_requisition_lines_all prl,
2825: rcv_shipment_lines rsl , po_req_distributions_all prd
2826: WHERE prl.requisition_header_id = p_reqHeaderID
2827: and rsl.item_id = inventory_item_id
2828: and prl.requisition_line_id = rsl.requisition_line_id
2829: and prl.requisition_line_id = prd.requisition_line_id

Line 2875: rcv_shipment_lines rsl , po_req_distributions_all prd

2871: ) )
2872: and mcr.inventory_item_id = msi.inventory_item_id
2873: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2874: and exists (SELECT 1 FROM po_requisition_lines_all prl,
2875: rcv_shipment_lines rsl , po_req_distributions_all prd
2876: WHERE prl.requisition_header_id = p_reqHeaderID
2877: and rsl.item_id = msi.inventory_item_id
2878: and prl.requisition_line_id = rsl.requisition_line_id
2879: and prl.requisition_line_id = prd.requisition_line_id