DBA Data[Home] [Help]

APPS.GML_UPDATE_CUST_DATA_PVT dependencies on OP_CUST_MST_V

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 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 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