APPS.BOM_COMPONENT_API dependencies on MTL_PARAMETERS

Line 134: FROM mtl_parameters a

130: stmt_num := 1;
131: LOOP
132: UPDATE bom_inventory_comps_interface ori
133: SET organization_id = (SELECT organization_id
134: FROM mtl_parameters a
135: WHERE a.organization_code = ori.organization_code)
136: WHERE process_flag = 1
137: AND upper(transaction_type) in (G_Insert, G_Delete, G_Update)
138: AND (UPPER(ori.interface_entity_type) = 'BILL'

Line 143: FROM mtl_parameters b

139: OR ori.interface_entity_type is null)
140: AND organization_id is null
141: AND organization_code is not null
142: AND exists (SELECT organization_code
143: FROM mtl_parameters b
144: WHERE b.organization_code = ori.organization_code)
145: AND rownum < G_rows_to_commit;
146: EXIT when SQL%NOTFOUND;
147: COMMIT;

Line 3081: FROM mtl_parameters

3077:
3078: stmt_num := 22;
3079: SELECT stock_locator_control_code
3080: INTO org_loc
3081: FROM mtl_parameters
3082: WHERE organization_id = c3rec.OI;
3083:
3084: IF (org_loc = 1) and (c3rec.SLI is not null) THEN
3085: RAISE write_loc_error;

Line 4270: FROM mtl_parameters

4266: /* Org level */
4267: stmt_num := 22;
4268: SELECT stock_locator_control_code
4269: INTO org_loc
4270: FROM mtl_parameters
4271: WHERE organization_id = c1rec.OI;
4272:
4273: IF (org_loc = 1) and (c1rec.SLI is not null) THEN
4274: RAISE write_loc_error;