DBA Data[Home] [Help]

APPS.GML_MOBILE_RECEIPT dependencies on PO_REQUISITION_LINES_ALL

Line 2824: and exists (SELECT 1 FROM po_requisition_lines_all prl,

2820: from mtl_system_items_kfv
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

Line 2874: and exists (SELECT 1 FROM po_requisition_lines_all prl,

2870: and mcr.organization_id = p_organization_id
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