APPS.INVUPD1B dependencies on MTL_PARAMETERS

Line 1430: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP

1426: CURSOR C_child_msi_records IS
1427: select
1428: MSI.INVENTORY_ITEM_ID,
1429: MSI.ORGANIZATION_ID
1430: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP
1431: where MP.master_organization_id = org_id
1432: and MP.organization_id = MSI.organization_id
1433: and MSI.inventory_item_id = inv_item_id
1434: and MSI.organization_id <> MP.master_organization_id;

Line 1449: from MTL_PARAMETERS MP

1445: END IF;
1446: -- if record is a master record
1447: select organization_id
1448: into tmp_org_id
1449: from MTL_PARAMETERS MP
1450: where MP.organization_id = org_id
1451: AND MP.master_organization_id = org_id;
1452:
1453: for rec in C_child_msi_records loop -- {

Line 4245: FROM mtl_parameters o

4241:
4242: --Assign Orgnization Id for missing ones
4243: UPDATE mtl_item_revisions_interface i
4244: SET i.organization_id = (SELECT o.organization_id
4245: FROM mtl_parameters o
4246: WHERE o.organization_code = i.organization_code)
4247: WHERE i.organization_id is NULL
4248: AND set_process_id = xset_id
4249: AND i.process_flag = l_process_flag_1;

Line 4346: FROM mtl_parameters

4342: IF l_rev_rec.revision_id IS NOT NULL THEN
4343:
4344: SELECT starting_revision
4345: INTO l_default_revision
4346: FROM mtl_parameters
4347: WHERE organization_id = cr.organization_id;
4348:
4349: IF l_default_revision = cr.revision THEN
4350: