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 879: ,JTF_RS_SALESREPS SPI

875: ,HZ_PARTIES HPCUSTNUM
876: ,HZ_PARTIES HPTPI
877: ,HZ_PARTIES HPTPN
878: ,HZ_PARTIES HPTPNUM
879: ,JTF_RS_SALESREPS SPI
880: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
881: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP
882: WHERE SP.RESOURCE_ID = SPTL.RESOURCE_ID
883: AND SPTL.LANGUAGE = USERENV('LANG')) SPN

Line 881: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP

877: ,HZ_PARTIES HPTPN
878: ,HZ_PARTIES HPTPNUM
879: ,JTF_RS_SALESREPS SPI
880: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
881: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP
882: WHERE SP.RESOURCE_ID = SPTL.RESOURCE_ID
883: AND SPTL.LANGUAGE = USERENV('LANG')) SPN
884: ,OE_AGREEMENTS_B AGI
885: ,OE_AGREEMENTS_TL AGTLN

Line 1843: ,JTF_RS_SALESREPS SRP

1839: ,(CASE WHEN HST.SALESGROUP_ID IS NOT NULL
1840: AND HST.SALESGROUP_ID <> -1
1841: AND NOT EXISTS (SELECT 'X'
1842: FROM JTF_RS_GROUP_MEMBERS MEM
1843: ,JTF_RS_SALESREPS SRP
1844: ,JTF_RS_GROUP_USAGES USG
1845: WHERE SRP.RESOURCE_ID = MEM.RESOURCE_ID
1846: AND MEM.GROUP_ID = USG.GROUP_ID
1847: AND USG.USAGE = 'SALES'

Line 5301: ,JTF_RS_SALESREPS SRP

5297: ,(CASE WHEN OSC.SALESGROUP_ID IS NULL OR
5298: (OSC.SALESGROUP_ID <> -1
5299: AND NOT EXISTS (SELECT 'X'
5300: FROM JTF_RS_GROUP_MEMBERS MEM
5301: ,JTF_RS_SALESREPS SRP
5302: ,JTF_RS_GROUP_USAGES USG
5303: WHERE SRP.RESOURCE_ID = MEM.RESOURCE_ID
5304: AND MEM.GROUP_ID = USG.GROUP_ID
5305: AND USG.USAGE = 'SALES'

Line 5337: ,JTF_RS_SALESREPS SPI

5333: FROM (SELECT SCI.ROWID ROW_ID, SCI.SALES_CREDIT_INTERFACE_ID, SCI.SALESPERSON_NAME, SCI.SALESPERSON_ID,
5334: SCI.SALESGROUP_ID, SCI.SALES_CREDIT_TYPE, SCI.PERCENT, HST.OPERATING_UNIT_ID
5335: FROM OKS_SALES_CREDITS_INTERFACE SCI, OKS_INT_HEADER_STG_TEMP HST
5336: WHERE SCI.HEADER_INTERFACE_ID = HST.HEADER_INTERFACE_ID) OSCI
5337: ,JTF_RS_SALESREPS SPI
5338: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
5339: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP
5340: WHERE SP.RESOURCE_ID = SPTL.RESOURCE_ID
5341: AND SPTL.LANGUAGE = USERENV('LANG')) SPN

Line 5339: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP

5335: FROM OKS_SALES_CREDITS_INTERFACE SCI, OKS_INT_HEADER_STG_TEMP HST
5336: WHERE SCI.HEADER_INTERFACE_ID = HST.HEADER_INTERFACE_ID) OSCI
5337: ,JTF_RS_SALESREPS SPI
5338: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
5339: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP
5340: WHERE SP.RESOURCE_ID = SPTL.RESOURCE_ID
5341: AND SPTL.LANGUAGE = USERENV('LANG')) SPN
5342: WHERE OSCI.SALESPERSON_ID = SPI.SALESREP_ID (+)
5343: AND OSCI.OPERATING_UNIT_ID = SPI.ORG_ID (+)