DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on ZX_PRODUCT_OPTIONS

Line 2149: AND NOT EXISTS (SELECT 'X' FROM ZX_PRODUCT_OPTIONS

2145: ,(CASE WHEN HST.TAX_EXEMPTION_CONTROL IS NOT NULL
2146: AND COUNT(DISTINCT TEC.ROWID) OVER (PARTITION BY HST.ROWID) <> 1
2147: THEN 'N' ELSE 'Y' END) TEC_V
2148: ,(CASE WHEN HST.TAX_EXEMPTION_CONTROL = 'E'
2149: AND NOT EXISTS (SELECT 'X' FROM ZX_PRODUCT_OPTIONS
2150: WHERE ORG_ID = HST.OPERATING_UNIT_ID
2151: AND TAX_METHOD_CODE <> 'LTE'
2152: AND APPLICATION_ID = 222
2153: AND TAX_USE_CUSTOMER_EXEMPT_FLAG = 'Y')

Line 3225: AND NOT EXISTS (SELECT 'X' FROM ZX_PRODUCT_OPTIONS

3221: ,(CASE WHEN LST.TAX_EXEMPTION_CONTROL IS NOT NULL
3222: AND COUNT(DISTINCT TEC.ROWID) OVER (PARTITION BY LST.ROWID) <> 1
3223: THEN 'N' ELSE 'Y' END) TEC_V
3224: ,(CASE WHEN LST.TAX_EXEMPTION_CONTROL = 'E'
3225: AND NOT EXISTS (SELECT 'X' FROM ZX_PRODUCT_OPTIONS
3226: WHERE ORG_ID = HDR.OPERATING_UNIT_ID
3227: AND TAX_METHOD_CODE <> 'LTE'
3228: AND APPLICATION_ID = 222
3229: AND TAX_USE_CUSTOMER_EXEMPT_FLAG = 'Y')