eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ECE_INO_LINE_TAX_V

Source

View Text - Preformatted


SELECT RCT.CUSTOMER_TRX_ID Transaction_ID, RCTL1.LINE_NUMBER Line_Number, RCTL2.CUSTOMER_TRX_LINE_ID Customer_Trx_Line_Id, RCTL2.LINE_NUMBER Tax_Line_Number, RCTL2.LINE_TYPE Line_Type, RCTL2.EXTENDED_AMOUNT Tax_Amount, RCTL2.TAX_RATE Tax_Rate, RCTL2.TAX_PRECEDENCE Tax_Precedence, ZRB.TAX Tax_Code, RCTL2.LINK_TO_CUST_TRX_LINE_ID Link_To_Cust_Trx_Line_Id, RCTL2.ATTRIBUTE_CATEGORY Tax_Attribute_Category, RCTL2.ATTRIBUTE1 Tax_Attribute1, RCTL2.ATTRIBUTE2 Tax_Attribute2, RCTL2.ATTRIBUTE3 Tax_Attribute3, RCTL2.ATTRIBUTE4 Tax_Attribute4, RCTL2.ATTRIBUTE5 Tax_Attribute5, RCTL2.ATTRIBUTE6 Tax_Attribute6, RCTL2.ATTRIBUTE7 Tax_Attribute7, RCTL2.ATTRIBUTE8 Tax_Attribute8, RCTL2.ATTRIBUTE9 Tax_Attribute9, RCTL2.ATTRIBUTE10 Tax_Attribute10, RCTL2.ATTRIBUTE11 Tax_Attribute11, RCTL2.ATTRIBUTE12 Tax_Attribute12, RCTL2.ATTRIBUTE13 Tax_Attribute13, RCTL2.ATTRIBUTE14 Tax_Attribute14, RCTL2.ATTRIBUTE15 Tax_Attribute15, RCTL2.TAX_EXEMPT_FLAG Tax_Exempt_Flag, RCTL2.TAX_EXEMPT_NUMBER Tax_Exempt_Number, RCTL2.TAX_EXEMPT_REASON_CODE Tax_Exempt_Reason_Code, ZTB.TAX_TYPE_CODE Tax_Type, ZRL.DESCRIPTION Description, null Location, null Tax_Classification, ZRB.vat_transaction_type_code Vat_Transaction_Type, ZRB.ATTRIBUTE_CATEGORY Vat_Tax_Attribute_Category, ZRB.ATTRIBUTE1 Vat_Tax_Attribute1, ZRB.ATTRIBUTE2 Vat_Tax_Attribute2, ZRB.ATTRIBUTE3 Vat_Tax_Attribute3, ZRB.ATTRIBUTE4 Vat_Tax_Attribute4, ZRB.ATTRIBUTE5 Vat_Tax_Attribute5, ZRB.ATTRIBUTE6 Vat_Tax_Attribute6, ZRB.ATTRIBUTE7 Vat_Tax_Attribute7, ZRB.ATTRIBUTE8 Vat_Tax_Attribute8, ZRB.ATTRIBUTE9 Vat_Tax_Attribute9, ZRB.ATTRIBUTE10 Vat_Tax_Attribute10, ZRB.ATTRIBUTE11 Vat_Tax_Attribute11, ZRB.ATTRIBUTE12 Vat_Tax_Attribute12, ZRB.ATTRIBUTE13 Vat_Tax_Attribute13, ZRB.ATTRIBUTE14 Vat_Tax_Attribute14, ZRB.ATTRIBUTE15 Vat_Tax_Attribute15 FROM RA_CUSTOMER_TRX_LINES RCTL1, RA_CUSTOMER_TRX RCT, RA_CUSTOMER_TRX_LINES RCTL2, ZX_RATES_B ZRB, ZX_TAXES_B ZTB, ZX_RATES_TL ZRL WHERE RCTL1.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID AND RCTL1.CUSTOMER_TRX_LINE_ID = RCTL2.LINK_TO_CUST_TRX_LINE_ID AND RCTL2.VAT_TAX_ID = ZRB.TAX_RATE_ID (+) AND RCTL1.LINE_TYPE != 'TAX' AND RCTL2.LINE_TYPE IN ('CHARGE', 'FREIGHT', 'TAX') and ZRB.TAX_RATE_ID =ZRL.TAX_RATE_ID AND ZRB.TAX_REGIME_CODE = ZTB.TAX_REGIME_CODE (+) AND ZRB.TAX = ZTB.TAX (+) AND ZRL.LANGUAGE(+) = userenv('LANG') AND (ZRB.CONTENT_OWNER_ID = ZTB.CONTENT_OWNER_ID OR ZTB.CONTENT_OWNER_ID = -99 OR ZRB.CONTENT_OWNER_ID IS NULL)

View Text - HTML Formatted

SELECT RCT.CUSTOMER_TRX_ID TRANSACTION_ID
, RCTL1.LINE_NUMBER LINE_NUMBER
, RCTL2.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, RCTL2.LINE_NUMBER TAX_LINE_NUMBER
, RCTL2.LINE_TYPE LINE_TYPE
, RCTL2.EXTENDED_AMOUNT TAX_AMOUNT
, RCTL2.TAX_RATE TAX_RATE
, RCTL2.TAX_PRECEDENCE TAX_PRECEDENCE
, ZRB.TAX TAX_CODE
, RCTL2.LINK_TO_CUST_TRX_LINE_ID LINK_TO_CUST_TRX_LINE_ID
, RCTL2.ATTRIBUTE_CATEGORY TAX_ATTRIBUTE_CATEGORY
, RCTL2.ATTRIBUTE1 TAX_ATTRIBUTE1
, RCTL2.ATTRIBUTE2 TAX_ATTRIBUTE2
, RCTL2.ATTRIBUTE3 TAX_ATTRIBUTE3
, RCTL2.ATTRIBUTE4 TAX_ATTRIBUTE4
, RCTL2.ATTRIBUTE5 TAX_ATTRIBUTE5
, RCTL2.ATTRIBUTE6 TAX_ATTRIBUTE6
, RCTL2.ATTRIBUTE7 TAX_ATTRIBUTE7
, RCTL2.ATTRIBUTE8 TAX_ATTRIBUTE8
, RCTL2.ATTRIBUTE9 TAX_ATTRIBUTE9
, RCTL2.ATTRIBUTE10 TAX_ATTRIBUTE10
, RCTL2.ATTRIBUTE11 TAX_ATTRIBUTE11
, RCTL2.ATTRIBUTE12 TAX_ATTRIBUTE12
, RCTL2.ATTRIBUTE13 TAX_ATTRIBUTE13
, RCTL2.ATTRIBUTE14 TAX_ATTRIBUTE14
, RCTL2.ATTRIBUTE15 TAX_ATTRIBUTE15
, RCTL2.TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, RCTL2.TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, RCTL2.TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, ZTB.TAX_TYPE_CODE TAX_TYPE
, ZRL.DESCRIPTION DESCRIPTION
, NULL LOCATION
, NULL TAX_CLASSIFICATION
, ZRB.VAT_TRANSACTION_TYPE_CODE VAT_TRANSACTION_TYPE
, ZRB.ATTRIBUTE_CATEGORY VAT_TAX_ATTRIBUTE_CATEGORY
, ZRB.ATTRIBUTE1 VAT_TAX_ATTRIBUTE1
, ZRB.ATTRIBUTE2 VAT_TAX_ATTRIBUTE2
, ZRB.ATTRIBUTE3 VAT_TAX_ATTRIBUTE3
, ZRB.ATTRIBUTE4 VAT_TAX_ATTRIBUTE4
, ZRB.ATTRIBUTE5 VAT_TAX_ATTRIBUTE5
, ZRB.ATTRIBUTE6 VAT_TAX_ATTRIBUTE6
, ZRB.ATTRIBUTE7 VAT_TAX_ATTRIBUTE7
, ZRB.ATTRIBUTE8 VAT_TAX_ATTRIBUTE8
, ZRB.ATTRIBUTE9 VAT_TAX_ATTRIBUTE9
, ZRB.ATTRIBUTE10 VAT_TAX_ATTRIBUTE10
, ZRB.ATTRIBUTE11 VAT_TAX_ATTRIBUTE11
, ZRB.ATTRIBUTE12 VAT_TAX_ATTRIBUTE12
, ZRB.ATTRIBUTE13 VAT_TAX_ATTRIBUTE13
, ZRB.ATTRIBUTE14 VAT_TAX_ATTRIBUTE14
, ZRB.ATTRIBUTE15 VAT_TAX_ATTRIBUTE15
FROM RA_CUSTOMER_TRX_LINES RCTL1
, RA_CUSTOMER_TRX RCT
, RA_CUSTOMER_TRX_LINES RCTL2
, ZX_RATES_B ZRB
, ZX_TAXES_B ZTB
, ZX_RATES_TL ZRL
WHERE RCTL1.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
AND RCTL1.CUSTOMER_TRX_LINE_ID = RCTL2.LINK_TO_CUST_TRX_LINE_ID
AND RCTL2.VAT_TAX_ID = ZRB.TAX_RATE_ID (+)
AND RCTL1.LINE_TYPE != 'TAX'
AND RCTL2.LINE_TYPE IN ('CHARGE'
, 'FREIGHT'
, 'TAX')
AND ZRB.TAX_RATE_ID =ZRL.TAX_RATE_ID
AND ZRB.TAX_REGIME_CODE = ZTB.TAX_REGIME_CODE (+)
AND ZRB.TAX = ZTB.TAX (+)
AND ZRL.LANGUAGE(+) = USERENV('LANG')
AND (ZRB.CONTENT_OWNER_ID = ZTB.CONTENT_OWNER_ID OR ZTB.CONTENT_OWNER_ID = -99 OR ZRB.CONTENT_OWNER_ID IS NULL)