Oracle EBS Latam Tax-AR Application Tax Options

Oracle EBS Latam Tax-AR Application Tax Options

Tables:-
ZX_PRODUCT_OPTIONS_ALL

SQL Example:-
SELECT 
b.name "OU Name"
,(SELECT meaning
     FROM Fnd_lookups
     WHERE lookup_type                 = DECODE(a.application_id,200, 'ZX_AP_DEFAULT_HIERARCHY',222, 'ZX_AR_DEFAULT_HIERARCHY',201, 'ZX_PO_DEFAULT_HIERARCHY',275, 'ZX_PA_DEFAULT_HIERARCHY', 8407,'ZX_IGC_DEFAULT_HIERARCHY')
     AND lookup_code                   = a.def_option_hier_1_code
     AND START_DATE_ACTIVE            <= SYSDATE
     AND NVL(END_DATE_ACTIVE, SYSDATE)>= SYSDATE
     AND ENABLED_FLAG                  = 'Y'  ) "Defaulting Order1"
,(SELECT Meaning
     FROM Fnd_lookups
     WHERE lookup_type                  = DECODE (a.application_id,200,'ZX_AP_DEFAULT_HIERARCHY',222, 'ZX_AR_DEFAULT_HIERARCHY',201, 'ZX_PO_DEFAULT_HIERARCHY',275, 'ZX_PA_DEFAULT_HIERARCHY',8407,'ZX_IGC_DEFAULT_HIERARCHY')
     AND lookup_code                    = a.DEF_OPTION_HIER_2_CODE
     AND START_DATE_ACTIVE             <= SYSDATE
     AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
     AND ENABLED_FLAG                   = 'Y'  ) "Defaulting Order2"
,(SELECT Meaning
     FROM Fnd_lookups
     WHERE lookup_type                  = DECODE (a.application_id,200, 'ZX_AP_DEFAULT_HIERARCHY',222,'ZX_AR_DEFAULT_HIERARCHY',201, 'ZX_PO_DEFAULT_HIERARCHY',275, 'ZX_PA_DEFAULT_HIERARCHY',8407,'ZX_IGC_DEFAULT_HIERARCHY')
     AND lookup_code                    = a.DEF_OPTION_HIER_3_CODE
     AND START_DATE_ACTIVE             <= SYSDATE
     AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
     AND ENABLED_FLAG                   = 'Y'   ) "Defaulting Order3"
,(SELECT meaning
     FROM Fnd_lookups
     WHERE lookup_type                  = DECODE (a.application_id,200, 'ZX_AP_DEFAULT_HIERARCHY',222, 'ZX_AR_DEFAULT_HIERARCHY',201,'ZX_PO_DEFAULT_HIERARCHY',275, 'ZX_PA_DEFAULT_HIERARCHY',8407,'ZX_IGC_DEFAULT_HIERARCHY')
     AND lookup_code                    = a.def_option_hier_4_code
     AND START_DATE_ACTIVE             <= SYSDATE
     AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
     AND ENABLED_FLAG                   = 'Y'   ) "Defaulting Order4"
,(SELECT meaning
     FROM Fnd_lookups
     WHERE lookup_type                  = DECODE (a.application_id,200, 'ZX_AP_DEFAULT_HIERARCHY',222, 'ZX_AR_DEFAULT_HIERARCHY',201, 'ZX_PO_DEFAULT_HIERARCHY',275, 'ZX_PA_DEFAULT_HIERARCHY',8407,'ZX_IGC_DEFAULT_HIERARCHY')
     AND lookup_code                    = a.DEF_OPTION_HIER_5_CODE
     AND START_DATE_ACTIVE             <= SYSDATE
     AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
     AND ENABLED_FLAG                   = 'Y'   ) "Defaulting Order5"
,a.tax_classification_code "System Option Tax Classi"
,(SELECT Meaning
     FROM Fnd_Lookups
     WHERE Lookup_Type                  = 'ZX_TAX_METHOD_OPTIONS'
     AND Lookup_Code                    = a.TAX_METHOD_CODE
     AND START_DATE_ACTIVE             <= SYSDATE
     AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
     AND ENABLED_FLAG                   = 'Y'  ) "Tax Determination Method"
,DECODE(a.tax_method_code,'LTE',NULL,c.Meaning) "Default Order Use Status"
FROM
APPS.ZX_PRODUCT_OPTIONS_ALL a,
APPS.HR_OPERATING_UNITS b,
APPS.FND_LOOKUPS c
WHERE 1=1
AND a.org_id= b.organization_id 
AND c.lookup_code                    = a.use_tax_classification_flag 
AND c.lookup_type                    = 'ZX_DEFAULTING_HIERARCHY_STATUS' 
AND c.start_date_active             <= SYSDATE 
AND NVL(c.end_date_active, SYSDATE) >= SYSDATE 
AND c.enabled_flag                   = 'Y' 
AND a.APPLICATION_ID =(SELECT fav.application_id   
FROM apps.fnd_application_vl fav   
WHERE fav.application_short_name='AR')
AND b.name= '&&';