eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GR_PROCESS_ORDERS dependencies on GR_ORDER_INFO_V

Line 74: gr_order_info_v om,

70: om.order_no,
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)

Line 97: gr_order_info_v om,

93: om.order_no,
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

Line 126: gr_order_info_v om,

122: om.order_no,
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)

Line 149: gr_order_info_v om,

145: om.order_no,
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

Line 180: gr_order_info_v om,

176: om.order_no,
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)

Line 203: gr_order_info_v om,

199: om.order_no,
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

Line 813: FROM gr_order_info_v

809:
810: CURSOR c_get_order_dtl
811: IS
812: SELECT distinct order_no, line_no
813: FROM gr_order_info_v
814: WHERE order_id = g_order_number;
815: LocalOrdDtl c_get_order_dtl%ROWTYPE;
816:
817: BEGIN