DBA Data[Home] [Help]

APPS.EGO_GTIN_PVT dependencies on MTL_PARAMETERS

Line 67: MTL_PARAMETERS MP

63: FROM MTL_CUSTOMER_ITEMS MCI,
64: MTL_CUSTOMER_ITEM_XREFS MCIX,
65: MTL_CROSS_REFERENCES MCR,
66: MTL_SYSTEM_ITEMS_B MSI,
67: MTL_PARAMETERS MP
68: WHERE MSI.INVENTORY_ITEM_ID = p_inventory_item_id
69: AND MSI.ORGANIZATION_ID = p_org_id
70: AND MSI.INVENTORY_ITEM_ID = MCIX.INVENTORY_ITEM_ID
71: AND MSI.ORGANIZATION_ID = MCIX.MASTER_ORGANIZATION_ID

Line 935: MTL_PARAMETERS MP

931: BEGIN
932: SELECT 'X' INTO l_temp
933: FROM MTL_CROSS_REFERENCES MCR,
934: MTL_SYSTEM_ITEMS_B MSI,
935: MTL_PARAMETERS MP
936: WHERE MCR.CROSS_REFERENCE_TYPE = 'GTIN'
937: AND MCR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
938: AND NVL(MCR.ORGANIZATION_ID, MSI.ORGANIZATION_ID) = MSI.ORGANIZATION_ID
939: AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID