[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | RA_CUSTOMER_TRX_LINES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  AR.RA_CUSTOMER_TRX_LINES_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| CUSTOMER_TRX_LINE_ID | NUMBER | (15) | Yes | |
| CUSTOMER_TRX_ID | NUMBER | (15) | Yes | |
| LINK_TO_CUST_TRX_LINE_ID | NUMBER | (15) | ||
| PREVIOUS_CUSTOMER_TRX_ID | NUMBER | (15) | ||
| PREVIOUS_CUSTOMER_TRX_LINE_ID | NUMBER | (15) | ||
| INITIAL_CUSTOMER_TRX_LINE_ID | NUMBER | (15) | ||
| LINE_NUMBER | NUMBER | Yes | ||
| LINE_TYPE | VARCHAR2 | (20) | Yes | |
| DESCRIPTION | VARCHAR2 | (240) | ||
| QUANTITY_ORDERED | NUMBER | |||
| QUANTITY_CREDITED | NUMBER | |||
| QUANTITY_INVOICED | NUMBER | |||
| QUANTITY | NUMBER | |||
| UNIT_STANDARD_PRICE | NUMBER | |||
| NET_UNIT_SELLING_PRICE | NUMBER | |||
| NET_EXTENDED_AMOUNT | NUMBER | Yes | ||
| REVENUE_AMOUNT | NUMBER | |||
| EXTENDED_AMOUNT | NUMBER | |||
| UNIT_SELLING_PRICE | NUMBER | |||
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | (7) | ||
| AMOUNT_INCLUDES_TAX_OVERRIDE | VARCHAR2 | (1) | ||
| UOM_CODE | VARCHAR2 | (3) | ||
| REASON_CODE | VARCHAR2 | (30) | ||
| ACCOUNTING_RULE_ID | NUMBER | (15) | ||
| ACCOUNTING_RULE_DURATION | NUMBER | (15) | ||
| RULE_START_DATE | DATE | |||
| AUTORULE_COMPLETE_FLAG | VARCHAR2 | (1) | ||
| AUTORULE_DURATION_PROCESSED | NUMBER | (15) | ||
| LAST_PERIOD_TO_CREDIT | NUMBER | |||
| ITEM_CONTEXT | VARCHAR2 | (30) | ||
| INVENTORY_ITEM_ID | NUMBER | (15) | ||
| MEMO_LINE_ID | NUMBER | (15) | ||
| TAXABLE_FLAG | VARCHAR2 | (1) | ||
| TAX_PRECEDENCE | NUMBER | |||
| TAX_RATE | NUMBER | |||
| ITEM_EXCEPTION_RATE_ID | NUMBER | (15) | ||
| TAX_EXEMPTION_ID | NUMBER | (15) | ||
| TAX_EXEMPT_FLAG | VARCHAR2 | (1) | ||
| TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | ||
| TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | ||
| TAX_VENDOR_RETURN_CODE | VARCHAR2 | (30) | ||
| SALES_TAX_ID | NUMBER | (15) | ||
| LOCATION_SEGMENT_ID | NUMBER | (15) | ||
| VAT_TAX_ID | NUMBER | (15) | ||
| AUTOTAX | VARCHAR2 | (1) | ||
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
| SALES_ORDER_SOURCE | VARCHAR2 | (50) | ||
| SALES_ORDER | VARCHAR2 | (50) | ||
| SALES_ORDER_REVISION | NUMBER | |||
| SALES_ORDER_LINE | VARCHAR2 | (30) | ||
| SALES_ORDER_DATE | DATE | |||
| MOVEMENT_ID | NUMBER | (15) | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| REQUEST_ID | NUMBER | (15) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
| PROGRAM_ID | NUMBER | (15) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| DEFAULT_USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
| DEFAULT_USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (30) | ||
| CUSTOMER_LANGUAGE | VARCHAR2 | (4) | ||
| INTERFACE_LINE_CONTEXT | VARCHAR2 | (30) | ||
| INTERFACE_LINE_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| INTERFACE_LINE_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| UOM_UNIT_OF_MEASURE_NAME | VARCHAR2 | (25) | ||
| AL_TAX_HANDLING_MEANING | VARCHAR2 | (80) | ||
| AL_REASON_MEANING | VARCHAR2 | (80) | ||
| RR_ACCOUNTING_RULE_NAME | VARCHAR2 | (30) | ||
| RR_ACCOUNTING_RULE_TYPE | VARCHAR2 | (10) | ||
| RR_FREQUENCY | VARCHAR2 | (15) | ||
| AL_TAX_EXEMPT_REASON_MEANING | VARCHAR2 | (80) | ||
| CTL_PREV_LINE_NUMBER | NUMBER | |||
| CTL_PREV_QUANTITY | NUMBER | |||
| UOM_PREV_UNIT_OF_MEASURE_NAME | VARCHAR2 | (25) | ||
| CTL_PREV_DESCRIPTION | VARCHAR2 | (240) | ||
| CTL_PREV_UNIT_SELLING_PRICE | NUMBER | |||
| CTL_PREV_NET_UNIT_SELL_PRICE | NUMBER | |||
| CTL_PREV_EXTENDED_AMOUNT | NUMBER | |||
| CTL_PREV_NET_EXTENDED_AMOUNT | NUMBER | |||
| PREV_LINE_BALANCE | NUMBER | |||
| CTL_PREV_ACCT_RULE_DURATION | NUMBER | (15) | ||
| CTL_REFERENCE | VARCHAR2 | (4000) | ||
| WAREHOUSE_ID | NUMBER | (15) | ||
| WAREHOUSE_NAME | VARCHAR2 | (240) | ||
| ML_MEMO_LINE_TYPE | VARCHAR2 | (30) | ||
| ML_MEMO_LINE_TAX_CODE | VARCHAR2 | (50) | ||
| ML_MEMO_LINE_UNIT_STD_PRICE | NUMBER | |||
| LAST_GL_DATE | DATE | |||
| TAX_CODE | VARCHAR2 | (50) | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| TRANSLATED_DESCRIPTION | VARCHAR2 | (1000) | ||
| PAYMENT_SET_ID | NUMBER | (15) | ||
| OE_HEADER_ID | NUMBER | |||
| SHIP_TO_CUSTOMER_ID | NUMBER | (15) | ||
| SHIP_TO_ADDRESS_ID | NUMBER | (15) | ||
| SHIP_TO_SITE_USE_ID | NUMBER | (15) | ||
| SHIP_TO_CONTACT_ID | NUMBER | (15) | ||
| HISTORICAL_FLAG | VARCHAR2 | (1) | ||
| TAX_LINE_ID | NUMBER | (15) | ||
| LINE_RECOVERABLE | NUMBER | |||
| TAX_RECOVERABLE | NUMBER | |||
| TAX_CLASSIFICATION_CODE | VARCHAR2 | (4000) | ||
| SHIP_TO_CUSTOMER_NAME | VARCHAR2 | (50) | ||
| SHIP_TO_CUSTOMER_NUM | VARCHAR2 | (30) | ||
| SHIP_TO_LOCATION | VARCHAR2 | (40) | ||
| SHIP_TO_ADDRESS1 | VARCHAR2 | (240) | ||
| SHIP_TO_ADDRESS2 | VARCHAR2 | (240) | ||
| SHIP_TO_ADDRESS3_DB | VARCHAR2 | (240) | ||
| SHIP_TO_ADDRESS3 | VARCHAR2 | (4000) | ||
| SHIP_TO_CITY | VARCHAR2 | (60) | ||
| SHIP_TO_COUNTY | VARCHAR2 | (60) | ||
| SHIP_TO_STATE | VARCHAR2 | (60) | ||
| SHIP_TO_PROVINCE | VARCHAR2 | (60) | ||
| SHIP_TO_POSTAL_CODE | VARCHAR2 | (60) | ||
| SHIP_TO_CONCAT_ADDRESS | VARCHAR2 | (4000) | ||
| SHIP_TO_CONTACT_NAME | VARCHAR2 | (92) | ||
| RULE_END_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CUSTOMER_TRX_LINE_ID
, CUSTOMER_TRX_ID
, LINK_TO_CUST_TRX_LINE_ID
, PREVIOUS_CUSTOMER_TRX_ID
, PREVIOUS_CUSTOMER_TRX_LINE_ID
, INITIAL_CUSTOMER_TRX_LINE_ID
, LINE_NUMBER
, LINE_TYPE
, DESCRIPTION
, QUANTITY_ORDERED
, QUANTITY_CREDITED
, QUANTITY_INVOICED
, QUANTITY
, UNIT_STANDARD_PRICE
, NET_UNIT_SELLING_PRICE
, NET_EXTENDED_AMOUNT
, REVENUE_AMOUNT
, EXTENDED_AMOUNT
, UNIT_SELLING_PRICE
, AMOUNT_INCLUDES_TAX_FLAG
, AMOUNT_INCLUDES_TAX_OVERRIDE
, UOM_CODE
, REASON_CODE
, ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, RULE_START_DATE
, AUTORULE_COMPLETE_FLAG
, AUTORULE_DURATION_PROCESSED
, LAST_PERIOD_TO_CREDIT
, ITEM_CONTEXT
, INVENTORY_ITEM_ID
, MEMO_LINE_ID
, TAXABLE_FLAG
, TAX_PRECEDENCE
, TAX_RATE
, ITEM_EXCEPTION_RATE_ID
, TAX_EXEMPTION_ID
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_VENDOR_RETURN_CODE
, SALES_TAX_ID
, LOCATION_SEGMENT_ID
, VAT_TAX_ID
, AUTOTAX
, SET_OF_BOOKS_ID
, SALES_ORDER_SOURCE
, SALES_ORDER
, SALES_ORDER_REVISION
, SALES_ORDER_LINE
, SALES_ORDER_DATE
, MOVEMENT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DEFAULT_USSGL_TRANSACTION_CODE
, DEFAULT_USSGL_TRX_CODE_CONTEXT
, CUSTOMER_LANGUAGE
, INTERFACE_LINE_CONTEXT
, INTERFACE_LINE_ATTRIBUTE1
, INTERFACE_LINE_ATTRIBUTE2
, INTERFACE_LINE_ATTRIBUTE3
, INTERFACE_LINE_ATTRIBUTE4
, INTERFACE_LINE_ATTRIBUTE5
, INTERFACE_LINE_ATTRIBUTE6
, INTERFACE_LINE_ATTRIBUTE7
, INTERFACE_LINE_ATTRIBUTE8
, INTERFACE_LINE_ATTRIBUTE9
, INTERFACE_LINE_ATTRIBUTE10
, INTERFACE_LINE_ATTRIBUTE11
, INTERFACE_LINE_ATTRIBUTE12
, INTERFACE_LINE_ATTRIBUTE13
, INTERFACE_LINE_ATTRIBUTE14
, INTERFACE_LINE_ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, UOM_UNIT_OF_MEASURE_NAME
, AL_TAX_HANDLING_MEANING
, AL_REASON_MEANING
, RR_ACCOUNTING_RULE_NAME
, RR_ACCOUNTING_RULE_TYPE
, RR_FREQUENCY
, AL_TAX_EXEMPT_REASON_MEANING
, CTL_PREV_LINE_NUMBER
, CTL_PREV_QUANTITY
, UOM_PREV_UNIT_OF_MEASURE_NAME
, CTL_PREV_DESCRIPTION
, CTL_PREV_UNIT_SELLING_PRICE
, CTL_PREV_NET_UNIT_SELL_PRICE
, CTL_PREV_EXTENDED_AMOUNT
, CTL_PREV_NET_EXTENDED_AMOUNT
, PREV_LINE_BALANCE
, CTL_PREV_ACCT_RULE_DURATION
, CTL_REFERENCE
, WAREHOUSE_ID
, WAREHOUSE_NAME
, ML_MEMO_LINE_TYPE
, ML_MEMO_LINE_TAX_CODE
, ML_MEMO_LINE_UNIT_STD_PRICE
, LAST_GL_DATE
, TAX_CODE
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, TRANSLATED_DESCRIPTION
, PAYMENT_SET_ID
, OE_HEADER_ID
, SHIP_TO_CUSTOMER_ID
, SHIP_TO_ADDRESS_ID
, SHIP_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID
, HISTORICAL_FLAG
, TAX_LINE_ID
, LINE_RECOVERABLE
, TAX_RECOVERABLE
, TAX_CLASSIFICATION_CODE
, SHIP_TO_CUSTOMER_NAME
, SHIP_TO_CUSTOMER_NUM
, SHIP_TO_LOCATION
, SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3_DB
, SHIP_TO_ADDRESS3
, SHIP_TO_CITY
, SHIP_TO_COUNTY
, SHIP_TO_STATE
, SHIP_TO_PROVINCE
, SHIP_TO_POSTAL_CODE
, SHIP_TO_CONCAT_ADDRESS
, SHIP_TO_CONTACT_NAME
, RULE_END_DATE
FROM APPS.RA_CUSTOMER_TRX_LINES_V;
APPS
ARH_ADDR_PKG
- show dependent code
ARPT_SQL_FUNC_UTIL
- show dependent code
ARP_BAL_UTIL
- show dependent code
ARP_TRX_LINE_UTIL
- show dependent code
AR_LOOKUPS
AR_MEMO_LINES
AR_VAT_TAX
FND_DATE
- show dependent code
FND_GLOBAL
- show dependent code
FND_LOOKUPS
FND_TERRITORIES_TL
HR_GENERAL
- show dependent code
HR_SECURITY
- show dependent code
HZ_CUST_ACCOUNTS
HZ_CUST_ACCOUNT_ROLES
HZ_CUST_ACCT_SITES
HZ_CUST_ACCT_SITES_ALL
HZ_CUST_SITE_USES
HZ_CUST_SITE_USES_ALL
HZ_LOCATIONS
HZ_PARTIES
HZ_PARTY_SITES
HZ_RELATIONSHIPS
MO_GLOBAL
- show dependent code
MTL_UNITS_OF_MEASURE
ORG_ORGANIZATION_DEFINITIONS
RA_CUSTOMER_TRX
RA_CUSTOMER_TRX_LINES_ALL
RA_CUST_TRX_TYPES_ALL
RA_RULES
APPS
AST_INVOICE_LINES_PVT
- show dependent code
IEX_INVOICE_LINES_V
|
|
|
|