DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on JTF_RS_RESOURCE_EXTNS_TL

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