APPS.BOM_REVISION_API dependencies on MTL_PARAMETERS

Line 91: FROM mtl_parameters a

87: stmt_num := 1;
88: LOOP
89: UPDATE mtl_item_revisions_interface ori
90: SET organization_id = (SELECT organization_id
91: FROM mtl_parameters a
92: WHERE a.organization_code = ori.organization_code)
93: WHERE process_flag = 1
94: AND upper(transaction_type) in (G_Insert, G_Update)
95: AND organization_id is null

Line 98: FROM mtl_parameters b

94: AND upper(transaction_type) in (G_Insert, G_Update)
95: AND organization_id is null
96: AND organization_code is not null
97: AND exists (SELECT organization_code
98: FROM mtl_parameters b
99: WHERE b.organization_code = ori.organization_code)
100: AND rownum < G_rows_to_commit;
101: EXIT when SQL%NOTFOUND;
102: COMMIT;

Line 728: FROM mtl_parameters

724: stmt_num := 6;
725: BEGIN
726: SELECT organization_id
727: INTO dummy_id
728: FROM mtl_parameters
729: WHERE organization_id = c0rec.OI;
730: EXCEPTION
731: WHEN No_Data_Found THEN
732: ret_code := INVPUOPI.mtl_log_interface_err(