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 OP_CUST_MST

Line 73: FROM op_cust_mst cust,

69: om.picking_ind,
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

Line 96: FROM op_cust_mst cust,

92: om.picking_ind,
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

Line 125: FROM op_cust_mst cust,

121: om.picking_ind,
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

Line 148: FROM op_cust_mst cust,

144: om.picking_ind,
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

Line 179: FROM op_cust_mst cust,

175: om.picking_ind,
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

Line 202: FROM op_cust_mst cust,

198: om.picking_ind,
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

Line 1845: FROM op_cust_mst cm

1841: */
1842: CURSOR c_get_customer_name
1843: IS
1844: SELECT cm.cust_name
1845: FROM op_cust_mst cm
1846: WHERE cm.cust_no = BatchDetails.recipient_code;
1847: LocalCustRecord c_get_customer_name%ROWTYPE;
1848:
1849: CURSOR c_get_language_code

Line 2482: FROM op_cust_mst cu

2478: */
2479: CURSOR c_get_cust_address
2480: IS
2481: SELECT cu.addr_id
2482: FROM op_cust_mst cu
2483: WHERE cu.cust_no = LocalRecipient.recipient_code;
2484: LocalCustRecord c_get_cust_address%ROWTYPE;
2485: /*
2486: ** Get the inventory items for a specified master item

Line 4354: L_CUSTOMER_ID OP_CUST_MST.cust_id%TYPE;

4350: L_INTEGRATION VARCHAR2(1); /* GK CHANGES*/
4351: /*
4352: ** Numeric Variables
4353: */
4354: L_CUSTOMER_ID OP_CUST_MST.cust_id%TYPE;
4355: L_ADDRESS_ID SY_ADDR_MST.addr_id%TYPE;
4356:
4357: X_MSG_COUNT NUMBER;
4358: L_FIRST_SPACE NUMBER;