DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on JTF_RS_RESOURCE_EXTNS_TL

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 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 (+)