[Home] [Help] [Dependency Information]
Object Name: | AS_TAX_LINES_SUMMARY_VBR |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JL.AS_TAX_LINES_SUMMARY_VBR |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_TO_CUSTOMER_ID | VARCHAR2 | (0) | ||
BILL_TO_CUSTOMER_ID | VARCHAR2 | (0) | ||
TRX_LINE_ID | VARCHAR2 | (0) | ||
TRX_HEADER_ID | VARCHAR2 | (0) | ||
TRX_LINK_TO_CUST_TRX_LINE_ID | VARCHAR2 | (0) | ||
TRX_DATE | VARCHAR2 | (0) | ||
GL_DATE | VARCHAR2 | (0) | ||
TAX_CODE | VARCHAR2 | (0) | ||
TAX_RATE | VARCHAR2 | (0) | ||
TAX_AMOUNT | VARCHAR2 | (0) | ||
SHIP_TO_SITE_USE_ID | VARCHAR2 | (0) | ||
BILL_TO_SITE_USE_ID | VARCHAR2 | (0) | ||
SHIP_TO_POSTAL_CODE | VARCHAR2 | (0) | ||
BILL_TO_POSTAL_CODE | VARCHAR2 | (0) | ||
INVENTORY_ITEM_ID | VARCHAR2 | (0) | ||
MEMO_LINE_ID | VARCHAR2 | (0) | ||
TAX_EXEMPT_FLAG | VARCHAR2 | (0) | ||
TAX_EXEMPT_NUMBER | VARCHAR2 | (0) | ||
TAX_EXEMPT_REASON_CODE | VARCHAR2 | (0) | ||
SHIP_TO_LOCATION_CCID | VARCHAR2 | (0) | ||
BILL_TO_LOCATION_CCID | VARCHAR2 | (0) | ||
INVOICING_RULE_ID | VARCHAR2 | (0) | ||
EXTENDED_AMOUNT | VARCHAR2 | (0) | ||
EXCHANGE_RATE | VARCHAR2 | (0) | ||
SET_OF_BOOKS_ID | VARCHAR2 | (0) | ||
CURRENCY_CODE | VARCHAR2 | (0) | ||
MINIMUM_ACCOUNTABLE_UNIT | VARCHAR2 | (0) | ||
PRECISION | VARCHAR2 | (0) | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (0) | ||
USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (0) | ||
REQUEST_ID | VARCHAR2 | (0) | ||
POO_ADDRESS_CODE | VARCHAR2 | (0) | ||
POA_ADDRESS_CODE | VARCHAR2 | (0) | ||
SHIP_FROM_ADDRESS_CODE | VARCHAR2 | (0) | ||
SHIP_TO_ADDRESS_CODE | VARCHAR2 | (0) | ||
FOB_CODE | VARCHAR2 | (0) | ||
TAXED_QUANTITY | VARCHAR2 | (0) | ||
PART_NUMBER | VARCHAR2 | (0) | ||
TAX_LINE_NUMBER | VARCHAR2 | (0) | ||
LOCATION_QUALIFIER | VARCHAR2 | (0) | ||
TAXABLE_FLAG | VARCHAR2 | (0) | ||
COMPOUNDING_PRECEDENCE | VARCHAR2 | (0) | ||
TAX_EXEMPTION_ID | VARCHAR2 | (0) | ||
TAX_EXCEPTION_ID | VARCHAR2 | (0) | ||
VENDOR_CONTROL_EXEMPTIONS | VARCHAR2 | (0) | ||
ATTRIBUTE1 | VARCHAR2 | (0) | ||
ATTRIBUTE2 | VARCHAR2 | (0) | ||
ATTRIBUTE3 | VARCHAR2 | (0) | ||
ATTRIBUTE4 | VARCHAR2 | (0) | ||
ATTRIBUTE5 | VARCHAR2 | (0) | ||
NUMERIC_ATTRIBUTE1 | VARCHAR2 | (0) | ||
NUMERIC_ATTRIBUTE2 | VARCHAR2 | (0) | ||
NUMERIC_ATTRIBUTE3 | VARCHAR2 | (0) | ||
NUMERIC_ATTRIBUTE4 | VARCHAR2 | (0) | ||
NUMERIC_ATTRIBUTE5 | VARCHAR2 | (0) | ||
TRX_NUMBER | VARCHAR2 | (0) | ||
SHIP_TO_CUSTOMER_NUMBER | VARCHAR2 | (0) | ||
SHIP_TO_CUSTOMER_NAME | VARCHAR2 | (0) | ||
BILL_TO_CUSTOMER_NUMBER | VARCHAR2 | (0) | ||
BILL_TO_CUSTOMER_NAME | VARCHAR2 | (0) | ||
PREVIOUS_TRX_LINE_ID | VARCHAR2 | (0) | ||
PREVIOUS_TRX_HEADER_ID | VARCHAR2 | (0) | ||
PREVIOUS_TRX_NUMBER | VARCHAR2 | (0) | ||
AUDIT_FLAG | VARCHAR2 | (0) | ||
TRX_LINE_TYPE | VARCHAR2 | (0) | ||
DIVISION_CODE | VARCHAR2 | (0) | ||
COMPANY_CODE | VARCHAR2 | (0) | ||
TAX_HEADER_LEVEL_FLAG | VARCHAR2 | (0) | ||
TAX_ROUNDING_RULE | VARCHAR2 | (0) | ||
VAT_TAX_ID | VARCHAR2 | (0) | ||
TRX_TYPE_ID | VARCHAR2 | (0) | ||
AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | (0) | ||
SHIP_FROM_WAREHOUSE_ID | VARCHAR2 | (0) | ||
PAYMENT_TERM_ID | VARCHAR2 | (0) | ||
PAYMENT_TERMS_DISCOUNT_PERCENT | VARCHAR2 | (0) | ||
TAXABLE_BASIS | VARCHAR2 | (0) | ||
TAX_CALCULATION_PLSQL_BLOCK | VARCHAR2 | (0) | ||
ATTRIBUTE6 | VARCHAR2 | (0) | ||
ATTRIBUTE7 | VARCHAR2 | (0) | ||
ATTRIBUTE8 | VARCHAR2 | (0) | ||
ATTRIBUTE9 | VARCHAR2 | (0) | ||
ATTRIBUTE10 | VARCHAR2 | (0) | ||
NUMERIC_ATTRIBUTE6 | VARCHAR2 | (0) | ||
NUMERIC_ATTRIBUTE7 | VARCHAR2 | (0) | ||
NUMERIC_ATTRIBUTE8 | VARCHAR2 | (0) | ||
NUMERIC_ATTRIBUTE9 | VARCHAR2 | (0) | ||
NUMERIC_ATTRIBUTE10 | VARCHAR2 | (0) |
Cut, paste (and edit) the following text to query this object:
SELECT SHIP_TO_CUSTOMER_ID
, BILL_TO_CUSTOMER_ID
, TRX_LINE_ID
, TRX_HEADER_ID
, TRX_LINK_TO_CUST_TRX_LINE_ID
, TRX_DATE
, GL_DATE
, TAX_CODE
, TAX_RATE
, TAX_AMOUNT
, SHIP_TO_SITE_USE_ID
, BILL_TO_SITE_USE_ID
, SHIP_TO_POSTAL_CODE
, BILL_TO_POSTAL_CODE
, INVENTORY_ITEM_ID
, MEMO_LINE_ID
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, SHIP_TO_LOCATION_CCID
, BILL_TO_LOCATION_CCID
, INVOICING_RULE_ID
, EXTENDED_AMOUNT
, EXCHANGE_RATE
, SET_OF_BOOKS_ID
, CURRENCY_CODE
, MINIMUM_ACCOUNTABLE_UNIT
, PRECISION
, USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT
, REQUEST_ID
, POO_ADDRESS_CODE
, POA_ADDRESS_CODE
, SHIP_FROM_ADDRESS_CODE
, SHIP_TO_ADDRESS_CODE
, FOB_CODE
, TAXED_QUANTITY
, PART_NUMBER
, TAX_LINE_NUMBER
, LOCATION_QUALIFIER
, TAXABLE_FLAG
, COMPOUNDING_PRECEDENCE
, TAX_EXEMPTION_ID
, TAX_EXCEPTION_ID
, VENDOR_CONTROL_EXEMPTIONS
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, NUMERIC_ATTRIBUTE1
, NUMERIC_ATTRIBUTE2
, NUMERIC_ATTRIBUTE3
, NUMERIC_ATTRIBUTE4
, NUMERIC_ATTRIBUTE5
, TRX_NUMBER
, SHIP_TO_CUSTOMER_NUMBER
, SHIP_TO_CUSTOMER_NAME
, BILL_TO_CUSTOMER_NUMBER
, BILL_TO_CUSTOMER_NAME
, PREVIOUS_TRX_LINE_ID
, PREVIOUS_TRX_HEADER_ID
, PREVIOUS_TRX_NUMBER
, AUDIT_FLAG
, TRX_LINE_TYPE
, DIVISION_CODE
, COMPANY_CODE
, TAX_HEADER_LEVEL_FLAG
, TAX_ROUNDING_RULE
, VAT_TAX_ID
, TRX_TYPE_ID
, AMOUNT_INCLUDES_TAX_FLAG
, SHIP_FROM_WAREHOUSE_ID
, PAYMENT_TERM_ID
, PAYMENT_TERMS_DISCOUNT_PERCENT
, TAXABLE_BASIS
, TAX_CALCULATION_PLSQL_BLOCK
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, NUMERIC_ATTRIBUTE6
, NUMERIC_ATTRIBUTE7
, NUMERIC_ATTRIBUTE8
, NUMERIC_ATTRIBUTE9
, NUMERIC_ATTRIBUTE10
FROM APPS.AS_TAX_LINES_SUMMARY_VBR;
APPS.AS_TAX_LINES_SUMMARY_VBR is not referenced by any database object
|
|
|