DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on AR_LOOKUPS

Line 2190: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC

2186: ,COUNT(DISTINCT HOI.ROWID) OVER (PARTITION BY HST.ROWID) HOI_COUNT
2187: FROM OKS_INT_HEADER_STG_TEMP HST
2188: ,FND_LOOKUPS TEC
2189: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
2190: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
2191: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)
2192: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN
2193: ,FND_LOOKUPS BS
2194: ,RA_CUST_TRX_TYPES_ALL BTXNTYPE

Line 3267: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC

3263: ,FND_LOOKUPS CR1
3264: ,FND_LOOKUPS CR2
3265: ,FND_LOOKUPS TEC
3266: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
3267: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
3268: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)
3269: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN
3270: ,FND_LOOKUPS RTC
3271: ,OKS_SUBSCR_HEADER_B TANGIBLE