eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_ITEM_ASSOCIATIONS_INTF

Line 1761: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai

1757: AND eia.PK1_VALUE = uai2.PK1_VALUE
1758: AND eia.DATA_LEVEL_ID = uai2.DATA_LEVEL_ID
1759: UNION ALL
1760: SELECT NULL
1761: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai
1762: WHERE (eiai.ITEM_NUMBER = uai2.ITEM_NUMBER -- Bug 13246699
1763: OR eiai.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID)
1764: AND eiai.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1765: AND eiai.PK1_VALUE = uai2.PK1_VALUE

Line 1793: FROM ego_item_associations_intf eiai

1789: AND eia.pk1_value = uai.pk1_value
1790: AND eia.data_level_id = uai.data_level_id
1791: UNION ALL
1792: SELECT NULL
1793: FROM ego_item_associations_intf eiai
1794: WHERE (eiai.ITEM_NUMBER = uai.ITEM_NUMBER -- Bug 13246699
1795: OR eiai.inventory_item_id = uai.inventory_item_id)
1796: AND eiai.organization_id = uai.organization_id
1797: AND eiai.pk1_value = uai.pk1_value

Line 1866: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai

1862: AND eia.PK2_VALUE = uai2.PK2_VALUE
1863: AND eia.DATA_LEVEL_ID = uai2.DATA_LEVEL_ID
1864: UNION ALL
1865: SELECT NULL
1866: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai
1867: WHERE (eiai.ITEM_NUMBER = uai2.ITEM_NUMBER -- Bug 13246699
1868: OR eiai.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID)
1869: AND eiai.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1870: AND eiai.PK1_VALUE = uai2.PK1_VALUE

Line 1901: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai

1897: AND eia.PK2_VALUE = uai.PK2_VALUE
1898: AND eia.DATA_LEVEL_ID = uai.DATA_LEVEL_ID
1899: UNION ALL
1900: SELECT NULL
1901: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai
1902: WHERE (eiai.ITEM_NUMBER = uai.ITEM_NUMBER -- Bug 13246699
1903: OR eiai.INVENTORY_ITEM_ID = uai.INVENTORY_ITEM_ID)
1904: AND eiai.ORGANIZATION_ID = uai.ORGANIZATION_ID
1905: AND eiai.PK1_VALUE = uai.PK1_VALUE

Line 1978: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai

1974: AND eia.PK2_VALUE = uai2.PK2_VALUE
1975: AND eia.DATA_LEVEL_ID = uai2.DATA_LEVEL_ID
1976: UNION ALL
1977: SELECT NULL
1978: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai
1979: WHERE (eiai.ITEM_NUMBER = uai2.ITEM_NUMBER -- Bug 13246699
1980: OR eiai.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID)
1981: AND eiai.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1982: AND eiai.PK1_VALUE = uai2.PK1_VALUE

Line 2012: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai

2008: AND eia.PK2_VALUE = uai.PK2_VALUE
2009: AND eia.DATA_LEVEL_ID = uai.DATA_LEVEL_ID
2010: UNION ALL
2011: SELECT NULL
2012: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai
2013: WHERE (eiai.ITEM_NUMBER = uai.ITEM_NUMBER -- Bug 13246699
2014: OR eiai.INVENTORY_ITEM_ID = uai.INVENTORY_ITEM_ID)
2015: AND eiai.ORGANIZATION_ID = uai.ORGANIZATION_ID
2016: AND eiai.PK1_VALUE = uai.PK1_VALUE