DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on OE_SALES_CREDIT_TYPES

Line 5469: ,OE_SALES_CREDIT_TYPES SCT

5465: AND SALES_CREDIT_TYPE = OSC.SALES_CREDIT_TYPE)
5466: THEN 'N' ELSE 'Y' END) UNIQ
5467: FROM OKS_SALES_CREDITS_INTERFACE OSC
5468: ,OKS_INT_HEADER_STG_TEMP HDR
5469: ,OE_SALES_CREDIT_TYPES SCT
5470: ,(SELECT distinct(OSCI.SALES_CREDIT_INTERFACE_ID) -- to avoid duplicate joins with tables when some names match with multiple records
5471: ,(CASE WHEN COUNT(DISTINCT SPI.ROWID) OVER (PARTITION BY OSCI.ROW_ID) = 1
5472: THEN MAX(OSCI.SALESPERSON_ID) OVER (PARTITION BY OSCI.ROW_ID) -- Sales Person Id Based on Id
5473: WHEN COUNT(DISTINCT SPN.ROW_ID) OVER (PARTITION BY OSCI.ROW_ID) = 1