DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AS_TAX_LINES_SUMMARY_VBR

Object Details
Object Name: AS_TAX_LINES_SUMMARY_VBR
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJL.AS_TAX_LINES_SUMMARY_VBR
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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)

Query Text

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;

Dependencies

[top of page]

APPS.AS_TAX_LINES_SUMMARY_VBR references the following:

SchemaPUBLIC
SynonymDUAL

APPS.AS_TAX_LINES_SUMMARY_VBR is not referenced by any database object