DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on RA_CUSTOMER_TRX_ALL

Line 801: ,RA_CUSTOMER_TRX_ALL CNI

797: ,FND_CURRENCIES FCUR
798: ,GL_DAILY_CONVERSION_TYPES GLCT
799: ,GL_DAILY_RATES GLDR
800: ,FND_LOOKUPS FL
801: ,RA_CUSTOMER_TRX_ALL CNI
802: ,FND_LOOKUPS PMC
803: ,(SELECT distinct(HDI.HEADER_INTERFACE_ID) -- to avoid duplicate joins with tables when some names match with multiple records
804: ,COUNT(DISTINCT HPCUSTI.ROWID) OVER (PARTITION BY HDI.ROWID) HPCUSTI_COUNT
805: ,MAX(HDI.CUSTOMER_PARTY_ID) OVER (PARTITION BY HDI.ROWID) HPCUSTI_ID -- CUSTOMER PARTY ID Based on Id

Line 2685: ,RA_CUSTOMER_TRX_ALL CNI

2681: END) LAST_BILL_FROM_DATE
2682: FROM OKS_LINES_INTERFACE OLI
2683: ,OKS_INT_HEADER_STG_TEMP HDR
2684: ,FND_LOOKUPS FL
2685: ,RA_CUSTOMER_TRX_ALL CNI
2686: ,FND_LOOKUPS PMC
2687: ,(SELECT LSE.ROWID ROW_ID, LSE.LTY_CODE, LSE.ID ID
2688: FROM OKC_LINE_STYLES_B LSE, FND_APPLICATION FA
2689: WHERE LSE.APPLICATION_ID = FA.APPLICATION_ID