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

Line 1701: -- pk1_value exists in ego_item_associations for this item --

1697: END LOOP; -- FOR i IN c_data_levels LOOP
1698:
1699: ----------------------------------------------------------------
1700: -- Next, validate the Item Supplier attrs. Validate that the --
1701: -- pk1_value exists in ego_item_associations for this item --
1702: ----------------------------------------------------------------
1703: IF p_validate_only = FND_API.G_FALSE THEN
1704: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1705: SET uai.PROCESS_STATUS = G_PS_BAD_SUPPLIER

Line 1723: FROM EGO_ITEM_ASSOCIATIONS eia

1719: OR
1720: ( uai2.PK1_VALUE IS NOT NULL
1721: AND uai2.PK2_VALUE IS NULL
1722: AND NOT EXISTS (SELECT NULL
1723: FROM EGO_ITEM_ASSOCIATIONS eia
1724: WHERE eia.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1725: AND eia.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1726: AND eia.PK1_VALUE = uai2.PK1_VALUE
1727: AND eia.DATA_LEVEL_ID = uai2.DATA_LEVEL_ID

Line 1754: FROM EGO_ITEM_ASSOCIATIONS eia

1750: OR
1751: ( uai2.PK1_VALUE IS NOT NULL
1752: AND uai2.PK2_VALUE IS NULL
1753: AND NOT EXISTS (SELECT NULL
1754: FROM EGO_ITEM_ASSOCIATIONS eia
1755: WHERE eia.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1756: AND eia.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1757: AND eia.PK1_VALUE = uai2.PK1_VALUE
1758: AND eia.DATA_LEVEL_ID = uai2.DATA_LEVEL_ID

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 1786: FROM ego_item_associations eia

1782: AND uai.pk2_value IS NOT NULL )
1783: OR ( uai.pk1_value IS NOT NULL
1784: AND uai.pk2_value IS NULL
1785: AND NOT EXISTS (SELECT NULL
1786: FROM ego_item_associations eia
1787: WHERE eia.inventory_item_id = uai.inventory_item_id
1788: AND eia.organization_id = uai.organization_id
1789: AND eia.pk1_value = uai.pk1_value
1790: AND eia.data_level_id = uai.data_level_id

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 1808: -- the pk2_value exists in ego_item_associations for this item --

1804: END IF;
1805:
1806: -----------------------------------------------------------------
1807: -- Next, validate the Item Supplier site attrs. Validate that --
1808: -- the pk2_value exists in ego_item_associations for this item --
1809: -----------------------------------------------------------------
1810: IF p_validate_only = FND_API.G_FALSE THEN
1811: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1812: SET uai.PROCESS_STATUS = G_PS_BAD_SUPPLIER_SITE

Line 1828: FROM EGO_ITEM_ASSOCIATIONS eia

1824: OR
1825: ( uai2.PK1_VALUE IS NOT NULL
1826: AND uai2.PK2_VALUE IS NOT NULL
1827: AND NOT EXISTS (SELECT NULL
1828: FROM EGO_ITEM_ASSOCIATIONS eia
1829: WHERE eia.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1830: AND eia.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1831: AND eia.PK1_VALUE = uai2.PK1_VALUE
1832: AND eia.PK2_VALUE = uai2.PK2_VALUE

Line 1858: FROM EGO_ITEM_ASSOCIATIONS eia

1854: OR
1855: ( uai2.PK1_VALUE IS NOT NULL
1856: AND uai2.PK2_VALUE IS NOT NULL
1857: AND NOT EXISTS (SELECT NULL
1858: FROM EGO_ITEM_ASSOCIATIONS eia
1859: WHERE eia.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1860: AND eia.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1861: AND eia.PK1_VALUE = uai2.PK1_VALUE
1862: AND eia.PK2_VALUE = uai2.PK2_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 1893: FROM EGO_ITEM_ASSOCIATIONS eia

1889: OR
1890: ( uai.PK1_VALUE IS NOT NULL
1891: AND uai.PK2_VALUE IS NOT NULL
1892: AND NOT EXISTS (SELECT NULL
1893: FROM EGO_ITEM_ASSOCIATIONS eia
1894: WHERE eia.INVENTORY_ITEM_ID = uai.INVENTORY_ITEM_ID
1895: AND eia.ORGANIZATION_ID = uai.ORGANIZATION_ID
1896: AND eia.PK1_VALUE = uai.PK1_VALUE
1897: AND eia.PK2_VALUE = uai.PK2_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 1920: -- in ego_item_associations for this item --

1916:
1917: ------------------------------------------------------------------
1918: -- Next, validate the Item Supplier site Org attrs. Validate --
1919: -- that the pk1,pk2_value along with the organization_id exists --
1920: -- in ego_item_associations for this item --
1921: ------------------------------------------------------------------
1922: IF p_validate_only = FND_API.G_FALSE THEN
1923: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1924: SET uai.PROCESS_STATUS = G_PS_BAD_SUPPLIER_SITE_ORG

Line 1940: FROM EGO_ITEM_ASSOCIATIONS eia

1936: OR
1937: ( uai2.PK1_VALUE IS NOT NULL
1938: AND uai2.PK2_VALUE IS NOT NULL
1939: AND NOT EXISTS (SELECT NULL
1940: FROM EGO_ITEM_ASSOCIATIONS eia
1941: WHERE eia.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1942: AND eia.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1943: AND eia.PK1_VALUE = uai2.PK1_VALUE
1944: AND eia.PK2_VALUE = uai2.PK2_VALUE

Line 1970: FROM EGO_ITEM_ASSOCIATIONS eia

1966: OR
1967: ( uai2.PK1_VALUE IS NOT NULL
1968: AND uai2.PK2_VALUE IS NOT NULL
1969: AND NOT EXISTS (SELECT NULL
1970: FROM EGO_ITEM_ASSOCIATIONS eia
1971: WHERE eia.INVENTORY_ITEM_ID = uai2.INVENTORY_ITEM_ID
1972: AND eia.ORGANIZATION_ID = uai2.ORGANIZATION_ID
1973: AND eia.PK1_VALUE = uai2.PK1_VALUE
1974: AND eia.PK2_VALUE = uai2.PK2_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 2004: FROM EGO_ITEM_ASSOCIATIONS eia

2000: OR
2001: ( uai.PK1_VALUE IS NOT NULL
2002: AND uai.PK2_VALUE IS NOT NULL
2003: AND NOT EXISTS (SELECT NULL
2004: FROM EGO_ITEM_ASSOCIATIONS eia
2005: WHERE eia.INVENTORY_ITEM_ID = uai.INVENTORY_ITEM_ID
2006: AND eia.ORGANIZATION_ID = uai.ORGANIZATION_ID
2007: AND eia.PK1_VALUE = uai.PK1_VALUE
2008: AND eia.PK2_VALUE = uai.PK2_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