DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on ZX_PRODUCT_OPTIONS

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

2175: ,(CASE WHEN HST.TAX_EXEMPTION_CONTROL IS NOT NULL
2176: AND COUNT(DISTINCT TEC.ROWID) OVER (PARTITION BY HST.ROWID) <> 1
2177: THEN 'N' ELSE 'Y' END) TEC_V
2178: ,(CASE WHEN HST.TAX_EXEMPTION_CONTROL = 'E'
2179: AND NOT EXISTS (SELECT 'X' FROM ZX_PRODUCT_OPTIONS
2180: WHERE ORG_ID = HST.OPERATING_UNIT_ID
2181: AND TAX_METHOD_CODE <> 'LTE'
2182: AND APPLICATION_ID = 222
2183: AND TAX_USE_CUSTOMER_EXEMPT_FLAG = 'Y')

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

3273: ,(CASE WHEN LST.TAX_EXEMPTION_CONTROL IS NOT NULL
3274: AND COUNT(DISTINCT TEC.ROWID) OVER (PARTITION BY LST.ROWID) <> 1
3275: THEN 'N' ELSE 'Y' END) TEC_V
3276: ,(CASE WHEN LST.TAX_EXEMPTION_CONTROL = 'E'
3277: AND NOT EXISTS (SELECT 'X' FROM ZX_PRODUCT_OPTIONS
3278: WHERE ORG_ID = HDR.OPERATING_UNIT_ID
3279: AND TAX_METHOD_CODE <> 'LTE'
3280: AND APPLICATION_ID = 222
3281: AND TAX_USE_CUSTOMER_EXEMPT_FLAG = 'Y')