APPS.INVUPD1B dependencies on MTL_PARAMETERS

Line 1446: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP

1442: CURSOR C_child_msi_records IS
1443: select
1444: MSI.INVENTORY_ITEM_ID,
1445: MSI.ORGANIZATION_ID
1446: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP
1447: where MP.master_organization_id = org_id
1448: and MP.organization_id = MSI.organization_id
1449: and MSI.inventory_item_id = inv_item_id
1450: and MSI.organization_id <> MP.master_organization_id;

Line 1465: from MTL_PARAMETERS MP

1461: END IF;
1462: -- if record is a master record
1463: select organization_id
1464: into tmp_org_id
1465: from MTL_PARAMETERS MP
1466: where MP.organization_id = org_id
1467: AND MP.master_organization_id = org_id;
1468:
1469: for rec in C_child_msi_records loop -- {

Line 4272: FROM mtl_parameters o

4268:
4269: --Assign Orgnization Id for missing ones
4270: UPDATE mtl_item_revisions_interface i
4271: SET i.organization_id = (SELECT o.organization_id
4272: FROM mtl_parameters o
4273: WHERE o.organization_code = i.organization_code)
4274: WHERE i.organization_id is NULL
4275: AND set_process_id = xset_id
4276: AND i.process_flag = l_process_flag_1;

Line 4374: FROM mtl_parameters

4370: IF l_rev_rec.revision_id IS NOT NULL THEN
4371:
4372: SELECT starting_revision
4373: INTO l_default_revision
4374: FROM mtl_parameters
4375: WHERE organization_id = cr.organization_id;
4376:
4377: IF l_default_revision = cr.revision THEN
4378: