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.OPI_EDW_OPMCOGS_F_C dependencies on RA_SALESREPS_ALL

Line 582: FROM RA_SALESREPS_ALL sr

578:
579: UPDATE OPI_EDW_COGS_FSTG cogs
580: SET PRIM_SALESRESOURCE_FK =
581: (select sr.salesrep_id||'-'||sr.org_id||'-'||cogs.instance_fk||'-SALESREP-PERS'
582: FROM RA_SALESREPS_ALL sr
583: WHERE sr.SALESREP_NUMBER = substrb(PRIM_SALESRESOURCE_FK,1,instrb(PRIM_SALESRESOURCE_FK,'-',-1,1)-1)
584: AND sr.org_id = substrb(PRIM_SALESRESOURCE_FK,instrb(PRIM_SALESRESOURCE_FK,'-',-1,1)+1))
585: WHERE PRIM_SALESRESOURCE_FK <> 'NA_EDW'
586: AND COLLECTION_STATUS = 'LOCAL READY';