View: AR_DEFAULT_TAX_CODE_V

View Text

SELECT SITE_USES.SITE_USE_ID SITE_USE_ID
, CUST_ACCT.CUST_ACCOUNT_ID CUSTOMER_ID
, I.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, I.ORGANIZATION_ID ORGANIZATION_ID
, P.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, T.START_DATE START_DATE
, T.END_DATE END_DATE
, T.TAX_CODE TAX_CODE
FROM HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_CUST_ACCT_SITES ACCT_SITE
, HZ_CUST_SITE_USES SITE_USES
, MTL_SYSTEM_ITEMS I
, AR_VAT_TAX T
, AR_SYSTEM_PARAMETERS P
WHERE CUST_ACCT.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID
AND ACCT_SITE.CUST_ACCT_SITE_ID = SITE_USES.CUST_ACCT_SITE_ID
AND T.TAX_CODE = DECODE(P.TAX_USE_SITE_EXC_RATE_FLAG
, 'Y'
, NVL( SITE_USES.TAX_CODE
, DECODE(P.TAX_USE_CUST_EXC_RATE_FLAG
, 'Y'
, NVL( CUST_ACCT.TAX_CODE
, DECODE(P.TAX_USE_PROD_EXC_RATE_FLAG
, 'Y'
, NVL(I.TAX_CODE
, DECODE(P.TAX_METHOD
, 'SALES_TAX'
, DECODE(T.TAX_TYPE
, 'LOCATION'
, T.TAX_CODE
, NULL)
, NULL ))
, DECODE(P.TAX_METHOD
, 'SALES_TAX'
, DECODE(T.TAX_TYPE
, 'LOCATION'
, T.TAX_CODE
, NULL )
, NULL )))
, DECODE(P.TAX_USE_PROD_EXC_RATE_FLAG
, 'Y'
, NVL(I.TAX_CODE
, DECODE(P.TAX_METHOD
, 'SALES_TAX'
, DECODE(T.TAX_TYPE
, 'LOCATION'
, T.TAX_CODE
, NULL)
, NULL ))
, DECODE(P.TAX_METHOD
, 'SALES_TAX'
, DECODE(T.TAX_TYPE
, 'LOCATION'
, T.TAX_CODE
, NULL)
, NULL ))))
, DECODE(P.TAX_USE_CUST_EXC_RATE_FLAG
, 'Y'
, NVL( CUST_ACCT.TAX_CODE
, DECODE(P.TAX_USE_PROD_EXC_RATE_FLAG
, 'Y'
, NVL(I.TAX_CODE
, DECODE(P.TAX_METHOD
, 'SALES_TAX'
, DECODE(T.TAX_TYPE
, 'LOCATION'
, T.TAX_CODE
, NULL)
, NULL ))
, DECODE(P.TAX_METHOD
, 'SALES_TAX'
, DECODE(T.TAX_TYPE
, 'LOCATION'
, T.TAX_CODE
, NULL)
, NULL )))
, DECODE(P.TAX_USE_PROD_EXC_RATE_FLAG
, 'Y'
, NVL(I.TAX_CODE
, DECODE(P.TAX_METHOD
, 'SALES_TAX'
, DECODE(T.TAX_TYPE
, 'LOCATION'
, T.TAX_CODE
, NULL)
, NULL ))
, DECODE(P.TAX_METHOD
, 'SALES_TAX'
, DECODE(T.TAX_TYPE
, 'LOCATION'
, T.TAX_CODE
, NULL)
, NULL))))

Columns