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.EDW_SICM_INV_LINES_HOOK dependencies on EDW_ITEM_ITEMORG_LTC

Line 19: (EdW_Item_ItemRev_LTC,EdW_Item_ItemOrg_LTC)

15:
16: -- Update UNSPSC
17: --Bug 3046583
18: /* Changed the logic to use data from level tables
19: (EdW_Item_ItemRev_LTC,EdW_Item_ItemOrg_LTC)
20: rather than star table (EDW_TIME_M) for updating
21: Invoice Lines Fact with UNSPC information. */
22:
23: Update FII_AP_INV_LINES_FSTG Fact

Line 27: EdW_Item_ItemOrg_LTC IOrg,

23: Update FII_AP_INV_LINES_FSTG Fact
24: set UNSPSC_FK =
25: (select Com.Function
26: from EdW_Item_ItemRev_LTC IRev,
27: EdW_Item_ItemOrg_LTC IOrg,
28: POA_DNB_ITEMS Com
29: where ((Fact.Item_FK = IRev.Item_Revision_PK) and
30: (IOrg.Item_Org_PK=IRev.Item_Org_FK) and
31: (IOrg.Item_Number_FK = Com.Item_PK)))

Line 35: EdW_Item_ItemOrg_LTC IOrg,

31: (IOrg.Item_Number_FK = Com.Item_PK)))
32: where ((Fact.Collection_Status = 'READY') and
33: (Fact.Item_FK IN (select IRev.Item_Revision_PK
34: from EdW_Item_ItemRev_LTC IRev,
35: EdW_Item_ItemOrg_LTC IOrg,
36: POA_DNB_ITEMS Com
37: where (IOrg.Item_Number_FK = Com.Item_PK) and
38: (IOrg.Item_Org_PK=IRev.Item_Org_FK))));
39: