DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on OE_SALES_CREDIT_TYPES

Line 5325: ,OE_SALES_CREDIT_TYPES SCT

5321: AND SALES_CREDIT_TYPE = OSC.SALES_CREDIT_TYPE)
5322: THEN 'N' ELSE 'Y' END) UNIQ
5323: FROM OKS_SALES_CREDITS_INTERFACE OSC
5324: ,OKS_INT_HEADER_STG_TEMP HDR
5325: ,OE_SALES_CREDIT_TYPES SCT
5326: ,(SELECT distinct(OSCI.SALES_CREDIT_INTERFACE_ID) -- to avoid duplicate joins with tables when some names match with multiple records
5327: ,(CASE WHEN COUNT(DISTINCT SPI.ROWID) OVER (PARTITION BY OSCI.ROW_ID) = 1
5328: THEN MAX(OSCI.SALESPERSON_ID) OVER (PARTITION BY OSCI.ROW_ID) -- Sales Person Id Based on Id
5329: WHEN COUNT(DISTINCT SPN.ROW_ID) OVER (PARTITION BY OSCI.ROW_ID) = 1