DBA Data[Home] [Help]

APPS.GR_PROCESS_ORDERS dependencies on MTL_SYSTEM_ITEMS

Line 75: mtl_system_items mtl

71: om.bol_no,
72: cust.cust_no
73: FROM op_cust_mst cust,
74: gr_order_info_v om,
75: mtl_system_items mtl
76: WHERE om.bol_id >= GlobalBatchHeader.shipment_from
77: AND om.bol_id <= GlobalBatchHeader.shipment_to
78: AND om.from_whse = TO_CHAR(g_default_orgid)
79: AND om.shipaddr_id = cust.of_ship_to_site_use_id

Line 127: mtl_system_items mtl

123: om.bol_no,
124: cust.cust_no
125: FROM op_cust_mst cust,
126: gr_order_info_v om,
127: mtl_system_items mtl
128: WHERE om.actual_shipdate >= GlobalBatchHeader.shipment_date_from
129: AND om.actual_shipdate <= GlobalBatchHeader.shipment_date_to
130: AND om.from_whse = TO_CHAR(g_default_orgid)
131: AND om.shipaddr_id = cust.of_ship_to_site_use_id

Line 181: mtl_system_items mtl

177: om.bol_no,
178: cust.cust_no
179: FROM op_cust_mst cust,
180: gr_order_info_v om,
181: mtl_system_items mtl
182: WHERE om.order_id >= GlobalBatchHeader.order_from
183: AND om.order_id <= GlobalBatchHeader.order_to
184: AND om.from_whse = TO_CHAR(g_default_orgid)
185: AND om.shipaddr_id = cust.of_ship_to_site_use_id