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 647: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2

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

Line 870: FROM MTL_PARAMETERS P1,

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

Line 871: MTL_PARAMETERS P2

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

Line 999: FROM MTL_PARAMETERS MP

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

Line 2009: MTL_PARAMETERS MP

2005: --Select the master org
2006: SELECT
2007: MP.MASTER_ORGANIZATION_ID INTO l_master_org
2008: FROM
2009: MTL_PARAMETERS MP
2010: WHERE
2011: MP.ORGANIZATION_ID = l_orgs(org_index);
2012:
2013: l_is_master_org := FND_API.G_FALSE;