DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on RA_CUSTOMER_TRX_ALL

Line 819: ,RA_CUSTOMER_TRX_ALL CNI

815: ,FND_CURRENCIES FCUR
816: ,GL_DAILY_CONVERSION_TYPES GLCT
817: ,GL_DAILY_RATES GLDR
818: ,FND_LOOKUPS FL
819: ,RA_CUSTOMER_TRX_ALL CNI
820: ,FND_LOOKUPS PMC
821: ,(SELECT distinct(HDI.HEADER_INTERFACE_ID) -- to avoid duplicate joins with tables when some names match with multiple records
822: ,COUNT(DISTINCT HPCUSTI.ROWID) OVER (PARTITION BY HDI.ROWID) HPCUSTI_COUNT
823: ,MAX(HDI.CUSTOMER_PARTY_ID) OVER (PARTITION BY HDI.ROWID) HPCUSTI_ID -- CUSTOMER PARTY ID Based on Id

Line 2727: ,RA_CUSTOMER_TRX_ALL CNI

2723: END) LAST_BILL_FROM_DATE
2724: FROM OKS_LINES_INTERFACE OLI
2725: ,OKS_INT_HEADER_STG_TEMP HDR
2726: ,FND_LOOKUPS FL
2727: ,RA_CUSTOMER_TRX_ALL CNI
2728: ,FND_LOOKUPS PMC
2729: ,(SELECT LSE.ROWID ROW_ID, LSE.LTY_CODE, LSE.ID ID
2730: FROM OKC_LINE_STYLES_B LSE, FND_APPLICATION FA
2731: WHERE LSE.APPLICATION_ID = FA.APPLICATION_ID