[Home] [Help] [Dependency Information]

VIEW: APPS.RA_CUSTOMER_TRX_LINES_V

Object Details

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

View Type

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.

[View Source]

Columns

Query Text

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;

Dependencies

[top of page]

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