APPS.EGO_MTL_SY_ITEMS_CHG_PKG dependencies on EGO_MTL_SY_ITEMS_CHG_TL

Line 47: INSERT INTO EGO_MTL_SY_ITEMS_CHG_TL (

43: or ( SUBB.LONG_DESCRIPTION is null and SUBT.LONG_DESCRIPTION is not null )
44: or ( SUBB.LONG_DESCRIPTION is not null and SUBT.LONG_DESCRIPTION is null ))));
45:
46: */
47: INSERT INTO EGO_MTL_SY_ITEMS_CHG_TL (
48: INVENTORY_ITEM_ID,
49: ORGANIZATION_ID,
50: DESCRIPTION,
51: LONG_DESCRIPTION,

Line 79: FROM EGO_MTL_SY_ITEMS_CHG_TL B,

75: B.CHANGE_ID,
76: B.CHANGE_LINE_ID,
77: B.ACD_TYPE,
78: B.IMPLEMENTATION_DATE
79: FROM EGO_MTL_SY_ITEMS_CHG_TL B,
80: FND_LANGUAGES L
81: WHERE L.INSTALLED_FLAG in ('I', 'B')
82: AND B.LANGUAGE = userenv('LANG')
83: AND NOT EXISTS( SELECT NULL

Line 84: FROM EGO_MTL_SY_ITEMS_CHG_TL T

80: FND_LANGUAGES L
81: WHERE L.INSTALLED_FLAG in ('I', 'B')
82: AND B.LANGUAGE = userenv('LANG')
83: AND NOT EXISTS( SELECT NULL
84: FROM EGO_MTL_SY_ITEMS_CHG_TL T
85: WHERE T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
86: AND T.ORGANIZATION_ID = B.ORGANIZATION_ID
87: AND T.LANGUAGE = L.LANGUAGE_CODE);
88: