DBA Data[Home] [Help]

APPS.GML_MOBILE_RECEIPT dependencies on OE_ORDER_LINES_ALL

Line 2731: oe_order_lines_all oel WHERE oel.HEADER_ID = p_oeOrderHeaderID

2727: WHERE organization_id = p_Organization_Id
2728: and concatenated_segments like p_concatenated_segments
2729: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2730: and inventory_item_id IN (SELECT oel.inventory_item_id FROM
2731: oe_order_lines_all oel WHERE oel.HEADER_ID = p_oeOrderHeaderID
2732: and oel.ORDERED_QUANTITY > NVL(oel.SHIPPED_QUANTITY,0)
2733: and ((p_projectId is null or oel.project_id = p_projectId)
2734: and (p_taskID is null or oel.task_id = p_taskId )) )
2735: UNION

Line 2777: oe_order_lines_all oel WHERE oel.HEADER_ID = p_oeOrderHeaderID

2773: ) )
2774: and mcr.inventory_item_id = msi.inventory_item_id
2775: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2776: and msi.inventory_item_id IN (SELECT oel.inventory_item_id FROM
2777: oe_order_lines_all oel WHERE oel.HEADER_ID = p_oeOrderHeaderID
2778: and oel.ORDERED_QUANTITY > NVL(oel.SHIPPED_QUANTITY,0)
2779: and ((p_projectId is null or oel.project_id = p_projectId)
2780: and (p_taskID is null or oel.task_id = p_taskId )) ) ;
2781: