DBA Data[Home] [Help]

APPS.GR_PROCESS_ORDERS dependencies on IC_ITEM_MST

Line 98: ic_item_mst ic

94: om.bol_no,
95: cust.cust_no
96: FROM op_cust_mst cust,
97: gr_order_info_v om,
98: ic_item_mst ic
99: WHERE om.bol_id >= GlobalBatchHeader.shipment_from
100: AND om.bol_id <= GlobalBatchHeader.shipment_to
101: AND om.from_whse = g_default_whse
102: AND om.shipcust_id = cust.cust_id

Line 150: ic_item_mst ic

146: om.bol_no,
147: cust.cust_no
148: FROM op_cust_mst cust,
149: gr_order_info_v om,
150: ic_item_mst ic
151: WHERE om.actual_shipdate >= GlobalBatchHeader.shipment_date_from
152: AND om.actual_shipdate <= GlobalBatchHeader.shipment_date_to
153: AND om.from_whse = g_default_whse
154: AND om.shipcust_id = cust.cust_id

Line 204: ic_item_mst ic

200: om.bol_no,
201: cust.cust_no
202: FROM op_cust_mst cust,
203: gr_order_info_v om,
204: ic_item_mst ic
205: WHERE om.order_id >= GlobalBatchHeader.order_from
206: AND om.order_id <= GlobalBatchHeader.order_to
207: AND om.from_whse = g_default_whse
208: AND om.shipcust_id = cust.cust_id