[Home] [Help] [Dependency Information]

VIEW: APPS.RA_CUSTOMER_TRX_LINES_RA_V

Object Details

Object Name:	RA_CUSTOMER_TRX_LINES_RA_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.RA_CUSTOMER_TRX_LINES_RA_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
,      EXTENDED_AMOUNT
,      REVENUE_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
,      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
,      CTL_REFERENCE
,      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
,      MC_CATEGORY_ID
,      MC_CATEGORY
,      NAME
FROM APPS.RA_CUSTOMER_TRX_LINES_RA_V;

Dependencies

[top of page]

APPS

AR_REVENUE_ADJUSTMENT_PVT - show dependent code

MTL_CATEGORIES

MTL_ITEM_CATEGORIES

RA_CUSTOMER_TRX

RA_CUSTOMER_TRX_LINES

RA_CUST_TRX_TYPES

RA_RULES

APPS.RA_CUSTOMER_TRX_LINES_RA_V is not referenced by any database object