APPS.BOM_BILL_API dependencies on MTL_PARAMETERS

Line 121: FROM mtl_parameters a

117: stmt_num := 1;
118: LOOP
119: UPDATE bom_bill_of_mtls_interface ori
120: SET organization_id = (SELECT organization_id
121: FROM mtl_parameters a
122: WHERE a.organization_code = ori.organization_code)
123: WHERE process_flag = 1
124: AND upper(transaction_type) in (G_Insert, G_Delete, G_Update)
125: AND organization_id is null

Line 128: FROM mtl_parameters b

124: AND upper(transaction_type) in (G_Insert, G_Delete, G_Update)
125: AND organization_id is null
126: AND organization_code is not null
127: AND exists (SELECT organization_code
128: FROM mtl_parameters b
129: WHERE b.organization_code = ori.organization_code)
130: AND rownum < G_rows_to_commit;
131: EXIT when SQL%NOTFOUND;
132: COMMIT;

Line 1335: FROM mtl_parameters mp1, mtl_parameters mp2

1331: stmt_num := 1;
1332: BEGIN
1333: SELECT 1
1334: INTO cnt
1335: FROM mtl_parameters mp1, mtl_parameters mp2
1336: WHERE mp1.organization_id = org_id
1337: AND mp2.organization_id = cmn_org_id
1338: AND mp1.master_organization_id = mp2.master_organization_id;
1339: EXCEPTION

Line 1653: FROM mtl_parameters

1649: */
1650: BEGIN
1651: SELECT organization_id
1652: INTO dummy_id
1653: FROM mtl_parameters
1654: WHERE organization_id = c1rec.OI;
1655: EXCEPTION
1656: WHEN no_data_found THEN
1657: ret_code := INVPUOPI.mtl_log_interface_err(