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.GML_UPDATE_CUST_DATA_PVT dependencies on OP_CUST_MST_OPM

Line 32: /* cust_id in op_cust_mst_opm passed to it. */

28: */
29:
30: /* ======================================================================= */
31: /* Function to get equivalent Bill To ID customer id on Apps side for a */
32: /* cust_id in op_cust_mst_opm passed to it. */
33: /* ======================================================================= */
34:
35: FUNCTION GET_BILLCUST_ID
36: (

Line 45: FROM op_cust_mst_v a, op_cust_mst_opm b

41: l_billcust_id NUMBER;
42: BEGIN
43:
44: SELECT a.cust_id INTO l_billcust_id
45: FROM op_cust_mst_v a, op_cust_mst_opm b
46: WHERE a.cust_no = b.cust_no
47: AND a.of_cust_id = b.of_cust_id --Bug 5651374 Performance issue.
48: AND a.co_code = b.co_code
49: AND b.cust_id = p_opm_cust_id

Line 63: /* cust_id in op_cust_mst_opm passed to it. */

59:
60:
61: /* ======================================================================= */
62: /* Function to get equivalent ship To ID customer id on Apps side for a */
63: /* cust_id in op_cust_mst_opm passed to it. */
64: /* ======================================================================= */
65:
66:
67: FUNCTION GET_SHIPCUST_ID

Line 78: FROM op_cust_mst_v a, op_cust_mst_opm b

74:
75: BEGIN
76:
77: SELECT a.cust_id INTO l_shipcust_id
78: FROM op_cust_mst_v a, op_cust_mst_opm b
79: WHERE a.cust_no = b.cust_no
80: AND a.of_cust_id = b.of_cust_id --Bug 5651374 Performance issue.
81: AND a.co_code = b.co_code
82: AND b.cust_id = p_opm_cust_id

Line 95: /* op_cust_mst_opm passed to it. In This particular case customer id */

91: END GET_SHIPCUST_ID;
92:
93: /* ======================================================================= */
94: /* Function to get first customer id on Apps side for a cust_id in */
95: /* op_cust_mst_opm passed to it. In This particular case customer id */
96: /* could be bill to as well as ship to. It can not be resolved in OPM */
97: /* How ever Customer_no displayed on the form for old records would still */
98: /* be the same. The forms are all Query Only. */
99: /* ======================================================================= */

Line 112: FROM op_cust_mst_v a, op_cust_mst_opm b

108:
109: BEGIN
110:
111: SELECT a.cust_id INTO l_anycust_id
112: FROM op_cust_mst_v a, op_cust_mst_opm b
113: WHERE a.cust_no = b.cust_no
114: AND a.of_cust_id = b.of_cust_id --Bug 5651374 Performance issue.
115: AND a.co_code = b.co_code
116: AND b.cust_id = p_opm_cust_id

Line 135: SELECT b.cust_id FROM op_cust_mst a, op_cust_mst_opm b

131: l_ship_cust_id NUMBER;
132: l_any_cust_id NUMBER;
133:
134: CURSOR Cur_cust_id IS
135: SELECT b.cust_id FROM op_cust_mst a, op_cust_mst_opm b
136: WHERE a.cust_no = b.cust_no
137: AND a.co_code = b.co_code;
138:
139: