790: ,OHI.SOURCE SOURCE
791: ,rtrim(OHI.DOCUMENT) DOCUMENT
792: FROM OKS_HEADERS_INTERFACE OHI
793: ,HR_ALL_ORGANIZATION_UNITS HOU
794: ,HR_ORGANIZATION_INFORMATION HOI
795: ,HZ_CUST_SITE_USES_ALL BTSUI
796: ,HZ_CUST_SITE_USES_ALL STSUI
797: ,FND_CURRENCIES FCUR
798: ,GL_DAILY_CONVERSION_TYPES GLCT
903: ,OKC_K_GROUPS_TL CGTLN
904: ,OKC_K_GROUPS_B CGBN
905: ,OKX_PARTY_CONTACTS_V CCAI
906: ,OKX_PARTY_CONTACTS_V CCAN
907: ,HR_ORGANIZATION_INFORMATION HOIPL
908: ,GL_LEDGERS GL
909: WHERE HDI.CUSTOMER_PARTY_ID = HPCUSTI.PARTY_ID (+)
910: AND HDI.CUSTOMER_PARTY_NAME = HPCUSTN.PARTY_NAME (+)
911: AND HDI.CUSTOMER_PARTY_NUMBER = HPCUSTNUM.PARTY_NUMBER (+)
2192: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN
2193: ,FND_LOOKUPS BS
2194: ,RA_CUST_TRX_TYPES_ALL BTXNTYPE
2195: ,FND_LOOKUPS SRC
2196: ,HR_ORGANIZATION_INFORMATION HOI
2197: WHERE HST.TAX_EXEMPTION_CONTROL = TEC.LOOKUP_CODE (+)
2198: AND TEC.LOOKUP_TYPE (+) = 'ZX_EXEMPTION_CONTROL'
2199: AND HST.TAX_EXEMPTION_NUMBER = TEN.EXEMPT_CERTIFICATE_NUMBER (+)
2200: AND HST.EXEMPT_REASON_CODE = TEN.EXEMPT_REASON_CODE (+)
3255: AND COUNT(DISTINCT TANGIBLE.ROWID) OVER (PARTITION BY LST.ROWID) = 1
3256: THEN 'Y' ELSE 'N' END) TANGIBLE_SUB
3257: FROM OKS_INT_LINE_STG_TEMP LST
3258: ,OKS_INT_HEADER_STG_TEMP HDR
3259: ,HR_ORGANIZATION_INFORMATION HOI
3260: ,OKS_COVERAGE_TEMPLTS_V COVTEM
3261: ,OKC_STATUSES_B STS
3262: ,OKC_STATUSES_B HDRSTS
3263: ,FND_LOOKUPS CR1