[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_CDMO_LINE_TAX_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  EC.ECE_CDMO_LINE_TAX_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view extracts line tax information
for the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | (15) | Yes | Transaction ID |
| LINE_NUMBER | NUMBER | Yes | Line Number | |
| CUSTOMER_TRX_LINE_ID | NUMBER | (15) | Yes | Customer Transaction Line Id |
| TAX_LINE_NUMBER | NUMBER | Yes | Tax Line Number | |
| LINE_TYPE | VARCHAR2 | (20) | Yes | Line Type |
| TAX_AMOUNT | NUMBER | Yes | Tax Amount | |
| TAX_RATE | NUMBER | Tax Rate | ||
| TAX_PRECEDENCE | NUMBER | Tax Precedence | ||
| TAX_CODE | VARCHAR2 | (50) | Tax Code (Internal) | |
| LINK_TO_CUST_TRX_LINE_ID | NUMBER | (15) | Tax Link To Customer Transaction Id | |
| TAX_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Tax Flexfield Context | |
| TAX_ATTRIBUTE1 | VARCHAR2 | (150) | Tax Flexfield 1 | |
| TAX_ATTRIBUTE2 | VARCHAR2 | (150) | Tax Flexfield 2 | |
| TAX_ATTRIBUTE3 | VARCHAR2 | (150) | Tax Flexfield 3 | |
| TAX_ATTRIBUTE4 | VARCHAR2 | (150) | Tax Flexfield 4 | |
| TAX_ATTRIBUTE5 | VARCHAR2 | (150) | Tax Flexfield 5 | |
| TAX_ATTRIBUTE6 | VARCHAR2 | (150) | Tax Flexfield 6 | |
| TAX_ATTRIBUTE7 | VARCHAR2 | (150) | Tax Flexfield 7 | |
| TAX_ATTRIBUTE8 | VARCHAR2 | (150) | Tax Flexfield 8 | |
| TAX_ATTRIBUTE9 | VARCHAR2 | (150) | Tax Flexfield 9 | |
| TAX_ATTRIBUTE10 | VARCHAR2 | (150) | Tax Flexfield 10 | |
| TAX_ATTRIBUTE11 | VARCHAR2 | (150) | Tax Flexfield 11 | |
| TAX_ATTRIBUTE12 | VARCHAR2 | (150) | Tax Flexfield 12 | |
| TAX_ATTRIBUTE13 | VARCHAR2 | (150) | Tax Flexfield 13 | |
| TAX_ATTRIBUTE14 | VARCHAR2 | (150) | Tax Flexfield 14 | |
| TAX_ATTRIBUTE15 | VARCHAR2 | (150) | Tax Flexfield 15 | |
| TAX_EXEMPT_FLAG | VARCHAR2 | (1) | Tax Exempt Flag | |
| TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | Tax Exempt Number | |
| TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax Exempt Reason Code | |
| TAX_TYPE | VARCHAR2 | (30) | Tax Type | |
| DESCRIPTION | VARCHAR2 | (60) | Description | |
| LOCATION | VARCHAR2 | (0) | Location | |
| TAX_CLASSIFICATION | VARCHAR2 | (0) | Tax Classification | |
| VAT_TRANSACTION_TYPE | VARCHAR2 | (30) | Vat Transaction Type | |
| VAT_TAX_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Vat Tax Flexfield Context | |
| VAT_TAX_ATTRIBUTE1 | VARCHAR2 | (150) | Vat Tax Flexfield 1 | |
| VAT_TAX_ATTRIBUTE2 | VARCHAR2 | (150) | Vat Tax Flexfield 2 | |
| VAT_TAX_ATTRIBUTE3 | VARCHAR2 | (150) | Vat Tax Flexfield 3 | |
| VAT_TAX_ATTRIBUTE4 | VARCHAR2 | (150) | Vat Tax Flexfield 4 | |
| VAT_TAX_ATTRIBUTE5 | VARCHAR2 | (150) | Vat Tax Flexfield 5 | |
| VAT_TAX_ATTRIBUTE6 | VARCHAR2 | (150) | Vat Tax Flexfield 6 | |
| VAT_TAX_ATTRIBUTE7 | VARCHAR2 | (150) | Vat Tax Flexfield 7 | |
| VAT_TAX_ATTRIBUTE8 | VARCHAR2 | (150) | Vat Tax Flexfield 8 | |
| VAT_TAX_ATTRIBUTE9 | VARCHAR2 | (150) | Vat Tax Flexfield 9 | |
| VAT_TAX_ATTRIBUTE10 | VARCHAR2 | (150) | Vat Tax Flexfield 10 | |
| VAT_TAX_ATTRIBUTE11 | VARCHAR2 | (150) | Vat Tax Flexfield 11 | |
| VAT_TAX_ATTRIBUTE12 | VARCHAR2 | (150) | Vat Tax Flexfield 12 | |
| VAT_TAX_ATTRIBUTE13 | VARCHAR2 | (150) | Vat Tax Flexfield 13 | |
| VAT_TAX_ATTRIBUTE14 | VARCHAR2 | (150) | Vat Tax Flexfield 14 | |
| VAT_TAX_ATTRIBUTE15 | VARCHAR2 | (150) | Vat Tax Flexfield 15 |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, LINE_NUMBER
, CUSTOMER_TRX_LINE_ID
, TAX_LINE_NUMBER
, LINE_TYPE
, TAX_AMOUNT
, TAX_RATE
, TAX_PRECEDENCE
, TAX_CODE
, LINK_TO_CUST_TRX_LINE_ID
, TAX_ATTRIBUTE_CATEGORY
, TAX_ATTRIBUTE1
, TAX_ATTRIBUTE2
, TAX_ATTRIBUTE3
, TAX_ATTRIBUTE4
, TAX_ATTRIBUTE5
, TAX_ATTRIBUTE6
, TAX_ATTRIBUTE7
, TAX_ATTRIBUTE8
, TAX_ATTRIBUTE9
, TAX_ATTRIBUTE10
, TAX_ATTRIBUTE11
, TAX_ATTRIBUTE12
, TAX_ATTRIBUTE13
, TAX_ATTRIBUTE14
, TAX_ATTRIBUTE15
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_TYPE
, DESCRIPTION
, LOCATION
, TAX_CLASSIFICATION
, VAT_TRANSACTION_TYPE
, VAT_TAX_ATTRIBUTE_CATEGORY
, VAT_TAX_ATTRIBUTE1
, VAT_TAX_ATTRIBUTE2
, VAT_TAX_ATTRIBUTE3
, VAT_TAX_ATTRIBUTE4
, VAT_TAX_ATTRIBUTE5
, VAT_TAX_ATTRIBUTE6
, VAT_TAX_ATTRIBUTE7
, VAT_TAX_ATTRIBUTE8
, VAT_TAX_ATTRIBUTE9
, VAT_TAX_ATTRIBUTE10
, VAT_TAX_ATTRIBUTE11
, VAT_TAX_ATTRIBUTE12
, VAT_TAX_ATTRIBUTE13
, VAT_TAX_ATTRIBUTE14
, VAT_TAX_ATTRIBUTE15
FROM APPS.ECE_CDMO_LINE_TAX_V;
APPS
AR_VAT_TAX
RA_CUSTOMER_TRX
RA_CUSTOMER_TRX_LINES
APPS.ECE_CDMO_LINE_TAX_V is not referenced by any database object
|
|
|
|