APPS.BOMPASGB dependencies on MTL_PARAMETERS

Line 57: mtl_parameters a

53: stmt_num := 1;
54: loop
55: update bom_bill_of_mtls_interface ori
56: set organization_id = (select organization_id from
57: mtl_parameters a
58: where a.organization_code = ori.organization_code)
59: where process_flag = 1
60: and organization_id is null
61: and organization_code is not null

Line 63: from mtl_parameters b

59: where process_flag = 1
60: and organization_id is null
61: and organization_code is not null
62: and exists (select organization_code
63: from mtl_parameters b
64: where b.organization_code = ori.organization_code)
65: and rownum < 2000;
66: EXIT when SQL%NOTFOUND;
67: commit;

Line 75: mtl_parameters a

71: stmt_num := 2;
72: loop
73: update bom_inventory_comps_interface ori
74: set organization_id = (select organization_id from
75: mtl_parameters a
76: where a.organization_code = ori.organization_code)
77: where process_flag = 1
78: and organization_id is null
79: and organization_code is not null

Line 81: from mtl_parameters b

77: where process_flag = 1
78: and organization_id is null
79: and organization_code is not null
80: and exists (select organization_code
81: from mtl_parameters b
82: where b.organization_code = ori.organization_code)
83: and rownum < 2000;
84: EXIT when SQL%NOTFOUND;
85: commit;

Line 93: mtl_parameters a

89: stmt_num := 4;
90: loop
91: update bom_ref_desgs_interface ori
92: set organization_id = (select organization_id from
93: mtl_parameters a
94: where a.organization_code = ori.organization_code)
95: where process_flag = 1
96: and organization_id is null
97: and organization_code is not null

Line 99: from mtl_parameters b

95: where process_flag = 1
96: and organization_id is null
97: and organization_code is not null
98: and exists (select organization_code
99: from mtl_parameters b
100: where b.organization_code = ori.organization_code)
101: and rownum < 2000;
102: EXIT when SQL%NOTFOUND;
103: commit;

Line 111: mtl_parameters a

107: stmt_num := 5;
108: loop
109: update bom_sub_comps_interface ori
110: set organization_id = (select organization_id from
111: mtl_parameters a
112: where a.organization_code = ori.organization_code)
113: where process_flag = 1
114: and organization_id is null
115: and organization_code is not null

Line 117: from mtl_parameters b

113: where process_flag = 1
114: and organization_id is null
115: and organization_code is not null
116: and exists (select organization_code
117: from mtl_parameters b
118: where b.organization_code = ori.organization_code)
119: and rownum < 2000;
120: EXIT when SQL%NOTFOUND;
121: commit;

Line 129: mtl_parameters a

125: stmt_num := 6;
126: loop
127: update mtl_item_revisions_interface ori
128: set organization_id = (select organization_id from
129: mtl_parameters a
130: where a.organization_code = ori.organization_code)
131: where process_flag = 1
132: and organization_id is null
133: and organization_code is not null

Line 135: from mtl_parameters b

131: where process_flag = 1
132: and organization_id is null
133: and organization_code is not null
134: and exists (select organization_code
135: from mtl_parameters b
136: where b.organization_code = ori.organization_code)
137: and rownum < 2000;
138: EXIT when SQL%NOTFOUND;
139: commit;