SELECT ROWID, TAXABLE_LINE_FLAG, TAX_TYPE_CODE, TAX_CODE_ID, TAX_ROUNDING_RULE_CODE, AMOUNT_INCLUDES_TAX_FLAG, TAX_DOCUMENT_IDENTIFIER, TAX_DOCUMENT_DATE, TAX_CUSTOMER_NAME, TAX_CUSTOMER_REFERENCE, TAX_REGISTRATION_NUMBER,
(DECODE (TAXABLE_LINE_FLAG,
'N', TAXABLE_LINE_FLAG,
'Y', TAXABLE_LINE_FLAG || '.' || TAX_TYPE_CODE || '.' || TAX_CODE_ID || '.' || TAX_ROUNDING_RULE_CODE || '.' || AMOUNT_INCLUDES_TAX_FLAG || '.' || TAX_DOCUMENT_IDENTIFIER || '.' || TAX_DOCUMENT_DATE || '.' || TAX_CUSTOMER_NAME || '.' || TAX_CUSTOMER_REFERENCE || '.' || TAX_REGISTRATION_NUMBER, NULL))
FROM GL_JE_LINES
SELECT ROWID
, TAXABLE_LINE_FLAG
, TAX_TYPE_CODE
, TAX_CODE_ID
, TAX_ROUNDING_RULE_CODE
, AMOUNT_INCLUDES_TAX_FLAG
, TAX_DOCUMENT_IDENTIFIER
, TAX_DOCUMENT_DATE
, TAX_CUSTOMER_NAME
, TAX_CUSTOMER_REFERENCE
, TAX_REGISTRATION_NUMBER
,
(DECODE (TAXABLE_LINE_FLAG
,
'N'
, TAXABLE_LINE_FLAG
,
'Y'
, TAXABLE_LINE_FLAG || '.' || TAX_TYPE_CODE || '.' || TAX_CODE_ID || '.' || TAX_ROUNDING_RULE_CODE || '.' || AMOUNT_INCLUDES_TAX_FLAG || '.' || TAX_DOCUMENT_IDENTIFIER || '.' || TAX_DOCUMENT_DATE || '.' || TAX_CUSTOMER_NAME || '.' || TAX_CUSTOMER_REFERENCE || '.' || TAX_REGISTRATION_NUMBER
, NULL))
FROM GL_JE_LINES
|
|
|