DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on AR_LOOKUPS

Line 2220: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC

2216: ,COUNT(DISTINCT HOI.ROWID) OVER (PARTITION BY HST.ROWID) HOI_COUNT
2217: FROM OKS_INT_HEADER_STG_TEMP HST
2218: ,FND_LOOKUPS TEC
2219: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
2220: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
2221: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)
2222: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN
2223: ,FND_LOOKUPS BS
2224: ,RA_CUST_TRX_TYPES_ALL BTXNTYPE

Line 3319: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC

3315: ,FND_LOOKUPS CR1
3316: ,FND_LOOKUPS CR2
3317: ,FND_LOOKUPS TEC
3318: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
3319: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
3320: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)
3321: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN
3322: ,FND_LOOKUPS RTC
3323: ,OKS_SUBSCR_HEADER_B TANGIBLE