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.OKS_IMPORT_VALIDATE dependencies on JTF_RS_SALESREPS

Line 909: ,JTF_RS_SALESREPS SPI

905: ,HZ_PARTIES HPCUSTNUM
906: ,HZ_PARTIES HPTPI
907: ,HZ_PARTIES HPTPN
908: ,HZ_PARTIES HPTPNUM
909: ,JTF_RS_SALESREPS SPI
910: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
911: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP
912: WHERE SP.RESOURCE_ID = SPTL.RESOURCE_ID
913: AND SPTL.LANGUAGE = USERENV('LANG')) SPN

Line 911: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP

907: ,HZ_PARTIES HPTPN
908: ,HZ_PARTIES HPTPNUM
909: ,JTF_RS_SALESREPS SPI
910: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
911: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP
912: WHERE SP.RESOURCE_ID = SPTL.RESOURCE_ID
913: AND SPTL.LANGUAGE = USERENV('LANG')) SPN
914: ,OE_AGREEMENTS_B AGI
915: ,OE_AGREEMENTS_TL AGTLN

Line 1873: ,JTF_RS_SALESREPS SRP

1869: ,(CASE WHEN HST.SALESGROUP_ID IS NOT NULL
1870: AND HST.SALESGROUP_ID <> -1
1871: AND NOT EXISTS (SELECT 'X'
1872: FROM JTF_RS_GROUP_MEMBERS MEM
1873: ,JTF_RS_SALESREPS SRP
1874: ,JTF_RS_GROUP_USAGES USG
1875: WHERE SRP.RESOURCE_ID = MEM.RESOURCE_ID
1876: AND MEM.GROUP_ID = USG.GROUP_ID
1877: AND USG.USAGE = 'SALES'

Line 5445: ,JTF_RS_SALESREPS SRP

5441: ,(CASE WHEN OSC.SALESGROUP_ID IS NULL OR
5442: (OSC.SALESGROUP_ID <> -1
5443: AND NOT EXISTS (SELECT 'X'
5444: FROM JTF_RS_GROUP_MEMBERS MEM
5445: ,JTF_RS_SALESREPS SRP
5446: ,JTF_RS_GROUP_USAGES USG
5447: WHERE SRP.RESOURCE_ID = MEM.RESOURCE_ID
5448: AND MEM.GROUP_ID = USG.GROUP_ID
5449: AND USG.USAGE = 'SALES'

Line 5481: ,JTF_RS_SALESREPS SPI

5477: FROM (SELECT SCI.ROWID ROW_ID, SCI.SALES_CREDIT_INTERFACE_ID, SCI.SALESPERSON_NAME, SCI.SALESPERSON_ID,
5478: SCI.SALESGROUP_ID, SCI.SALES_CREDIT_TYPE, SCI.PERCENT, HST.OPERATING_UNIT_ID
5479: FROM OKS_SALES_CREDITS_INTERFACE SCI, OKS_INT_HEADER_STG_TEMP HST
5480: WHERE SCI.HEADER_INTERFACE_ID = HST.HEADER_INTERFACE_ID) OSCI
5481: ,JTF_RS_SALESREPS SPI
5482: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
5483: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP
5484: WHERE SP.RESOURCE_ID = SPTL.RESOURCE_ID
5485: AND SPTL.LANGUAGE = USERENV('LANG')) SPN

Line 5483: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP

5479: FROM OKS_SALES_CREDITS_INTERFACE SCI, OKS_INT_HEADER_STG_TEMP HST
5480: WHERE SCI.HEADER_INTERFACE_ID = HST.HEADER_INTERFACE_ID) OSCI
5481: ,JTF_RS_SALESREPS SPI
5482: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
5483: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP
5484: WHERE SP.RESOURCE_ID = SPTL.RESOURCE_ID
5485: AND SPTL.LANGUAGE = USERENV('LANG')) SPN
5486: WHERE OSCI.SALESPERSON_ID = SPI.SALESREP_ID (+)
5487: AND OSCI.OPERATING_UNIT_ID = SPI.ORG_ID (+)