APPS.EGO_ITEM_LC_IMP_PC_PUB dependencies on MTL_PARAMETERS

Line 87: FROM MTL_PARAMETERS P1,

83: FROM eng_revised_items change
84: WHERE revised_item_id = cp_item_id
85: AND organization_id IN
86: (SELECT P2.ORGANIZATION_ID
87: FROM MTL_PARAMETERS P1,
88: MTL_PARAMETERS P2
89: WHERE P1.ORGANIZATION_ID = cp_org_id
90: AND P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID
91: )

Line 88: MTL_PARAMETERS P2

84: WHERE revised_item_id = cp_item_id
85: AND organization_id IN
86: (SELECT P2.ORGANIZATION_ID
87: FROM MTL_PARAMETERS P1,
88: MTL_PARAMETERS P2
89: WHERE P1.ORGANIZATION_ID = cp_org_id
90: AND P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID
91: )
92: AND nvl(current_item_revision_id, -1) = nvl(cp_rev_id, nvl(current_item_revision_id,-1))

Line 449: MTL_PARAMETERS MP

445: MSI.description,
446: MSI.concatenated_segments,
447: MP.ORGANIZATION_CODE
448: FROM MTL_SYSTEM_ITEMS_KFV MSI,
449: MTL_PARAMETERS MP
450: WHERE
451: MSI.INVENTORY_ITEM_ID = p_inventory_item_id
452: AND MSI.ORGANIZATION_ID = p_organization_id
453: AND MSI.Organization_ID = MP.Organization_ID;

Line 649: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2

645: WHERE
646: INVENTORY_ITEM_ID = p_inventory_item_id
647: AND ORGANIZATION_ID IN
648: (SELECT P2.ORGANIZATION_ID
649: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2
650: WHERE P1.ORGANIZATION_ID = p_organization_id
651: AND P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID);
652: l_phase_update := 'Y';
653: END LOOP;

Line 872: FROM MTL_PARAMETERS P1,

868: INVENTORY_ITEM_ID = l_pending_record.INVENTORY_ITEM_ID
869: AND REVISION = l_current_revision
870: AND ORGANIZATION_ID IN
871: (SELECT P2.ORGANIZATION_ID
872: FROM MTL_PARAMETERS P1,
873: MTL_PARAMETERS P2
874: WHERE P1.ORGANIZATION_ID = p_organization_id
875: AND P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID);
876:

Line 873: MTL_PARAMETERS P2

869: AND REVISION = l_current_revision
870: AND ORGANIZATION_ID IN
871: (SELECT P2.ORGANIZATION_ID
872: FROM MTL_PARAMETERS P1,
873: MTL_PARAMETERS P2
874: WHERE P1.ORGANIZATION_ID = p_organization_id
875: AND P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID);
876:
877: ELSIF (FND_API.TO_BOOLEAN(p_revision_master_controlled) = FALSE) THEN

Line 1001: FROM MTL_PARAMETERS MP

997: SELECT DECODE(MP.ORGANIZATION_ID,
998: MP.MASTER_ORGANIZATION_ID, FND_API.G_TRUE,
999: FND_API.G_FALSE)
1000: INTO l_is_master_org
1001: FROM MTL_PARAMETERS MP
1002: WHERE MP.ORGANIZATION_ID = p_organization_id;
1003:
1004: RETURN l_is_master_org;
1005:

Line 2076: MTL_PARAMETERS MP

2072: --Select the master org
2073: SELECT
2074: MP.MASTER_ORGANIZATION_ID INTO l_master_org
2075: FROM
2076: MTL_PARAMETERS MP
2077: WHERE
2078: MP.ORGANIZATION_ID = l_orgs(org_index);
2079:
2080: l_is_master_org := FND_API.G_FALSE;