eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.AR_INVOICE_LINES_V

Object Details

Object Name:	AR_INVOICE_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_INVOICE_LINES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

The AR_INVOICE_LINES_V view, which is one of eight transaction printing views that Oracle Receivables provides, collects line-level information for each transaction that is selected by the AR_INVOICE_HEADER_V view. A system administrator or Oracle consultant can use transaction printing views to extract transaction information from Receivables and then print the data in a custom format using Oracle Reports or a similar, SQL-based report generator.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_TRX_ID	NUMBER	(15)	Yes	Refer to base table.
CUSTOMER_TRX_LINE_ID	NUMBER	(15)	Yes	Refer to base table.
LINE_NUMBER	NUMBER			Refer to base table.
LINE_TYPE	VARCHAR2	(20)	Yes	Refer to base table.
ITEM_DESCRIPTION	VARCHAR2	(4000)		Refer to base table.
QUANTITY_ORDERED	NUMBER			Refer to base table.
QUANTITY	NUMBER			Refer to base table.
UNIT_OF_MEASURE_NAME	VARCHAR2	(25)		Refer to base table.
ITEM_CODE	VARCHAR2	(150)		Refer to base table.
UNIT_SELLING_PRICE	NUMBER			Refer to base table.
EXTENDED_AMOUNT	NUMBER		Yes	Refer to base table.
SALES_ORDER	VARCHAR2	(50)		Refer to base table.
SALES_ORDER_DATE	DATE			Refer to base table.
TAX_RATE	NUMBER			Refer to base table.
VAT_TAX_ID	NUMBER	(15)		Refer to base table.
PRINTED_TAX_NAME	VARCHAR2	(60)		Refer to base table.
TAX_EXEMPTION_ID	NUMBER	(15)		Refer to base table.
PERCENT_EXEMPTION	VARCHAR2	(40)		Refer to base table.
EXEMPTION_TYPE	VARCHAR2	(30)		Refer to base table.
LOCATION_RATE_ID	NUMBER	(15)		Refer to base table.
TAX_PRECEDENCE	NUMBER			Refer to base table.
LINK_TO_CUST_TRX_LINE_ID	NUMBER	(15)		Refer to base table.
TAX_EXISTS_FOR_THIS_LINE_FLAG	VARCHAR2	(4000)		Refer to base table.
ITEM_EXCEPTION_RATE_ID	NUMBER	(15)		Refer to base table.
MEMO_LINE_ID	NUMBER	(15)		Refer to base table.
AUTORULE_DURATION_PROCESSED	NUMBER	(15)		Refer to base table.
UOM_CODE	VARCHAR2	(3)		Refer to base table.
DEFAULT_USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Refer to base table.
DEFAULT_USSGL_TRX_CODE_CONTEXT	VARCHAR2	(30)		Refer to base table.
AUTOTAX	VARCHAR2	(1)		Refer to base table.
LAST_PERIOD_TO_CREDIT	NUMBER			Refer to base table.
ITEM_CONTEXT	VARCHAR2	(30)		Refer to base table.
TAX_EXEMPT_FLAG	VARCHAR2	(1)		Refer to base table.
TAX_EXEMPT_NUMBER	VARCHAR2	(80)		Refer to base table.
TAX_EXEMPT_REASON_CODE	VARCHAR2	(30)		Refer to base table.
TAX_VENDOR_RETURN_CODE	VARCHAR2	(30)		Refer to base table.
LOCATION_SEGMENT_ID	NUMBER	(15)		Refer to base table.
MOVEMENT_ID	NUMBER	(15)		Refer to base table.
ORG_ID	NUMBER	(15)		Organization identifier
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
RULE_START_DATE	DATE			Refer to base table.
INITIAL_CUSTOMER_TRX_LINE_ID	NUMBER	(15)		Refer to base table.
SALES_ORDER_SOURCE	VARCHAR2	(50)		Refer to base table.
TAXABLE_FLAG	VARCHAR2	(1)		Refer to base table.
REVENUE_AMOUNT	NUMBER			Refer to base table.
AUTORULE_COMPLETE_FLAG	VARCHAR2	(1)		Refer to base table.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Refer to base table.
REASON_CODE	VARCHAR2	(30)		Refer to base table.
INVENTORY_ITEM_ID	NUMBER	(15)		Refer to base table.
PREVIOUS_CUSTOMER_TRX_ID	NUMBER	(15)		Refer to base table.
PREVIOUS_CUSTOMER_TRX_LINE_ID	NUMBER	(15)		Refer to base table.
QUANTITY_CREDITED	NUMBER			Refer to base table.
UNIT_STANDARD_PRICE	NUMBER			Refer to base table.
SALES_ORDER_REVISION	NUMBER			Refer to base table.
SALES_ORDER_LINE	VARCHAR2	(30)		Refer to base table.
ACCOUNTING_RULE_ID	NUMBER	(15)		Refer to base table.
ACCOUNTING_RULE_DURATION	NUMBER	(15)		Refer to base table.
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Refer to base table.
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Refer to base table.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
INTERFACE_LINE_CONTEXT	VARCHAR2	(30)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE1	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE2	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE3	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE4	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE5	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE6	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE7	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE8	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE9	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE10	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE11	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE12	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE13	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE14	VARCHAR2	(150)		Refer to base table.
INTERFACE_LINE_ATTRIBUTE15	VARCHAR2	(150)		Refer to base table.
WH_UPDATE_DATE	DATE			Refer to base table.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      LINE_NUMBER
,      LINE_TYPE
,      ITEM_DESCRIPTION
,      QUANTITY_ORDERED
,      QUANTITY
,      UNIT_OF_MEASURE_NAME
,      ITEM_CODE
,      UNIT_SELLING_PRICE
,      EXTENDED_AMOUNT
,      SALES_ORDER
,      SALES_ORDER_DATE
,      TAX_RATE
,      VAT_TAX_ID
,      PRINTED_TAX_NAME
,      TAX_EXEMPTION_ID
,      PERCENT_EXEMPTION
,      EXEMPTION_TYPE
,      LOCATION_RATE_ID
,      TAX_PRECEDENCE
,      LINK_TO_CUST_TRX_LINE_ID
,      TAX_EXISTS_FOR_THIS_LINE_FLAG
,      ITEM_EXCEPTION_RATE_ID
,      MEMO_LINE_ID
,      AUTORULE_DURATION_PROCESSED
,      UOM_CODE
,      DEFAULT_USSGL_TRANSACTION_CODE
,      DEFAULT_USSGL_TRX_CODE_CONTEXT
,      AUTOTAX
,      LAST_PERIOD_TO_CREDIT
,      ITEM_CONTEXT
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      TAX_VENDOR_RETURN_CODE
,      LOCATION_SEGMENT_ID
,      MOVEMENT_ID
,      ORG_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RULE_START_DATE
,      INITIAL_CUSTOMER_TRX_LINE_ID
,      SALES_ORDER_SOURCE
,      TAXABLE_FLAG
,      REVENUE_AMOUNT
,      AUTORULE_COMPLETE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SET_OF_BOOKS_ID
,      REASON_CODE
,      INVENTORY_ITEM_ID
,      PREVIOUS_CUSTOMER_TRX_ID
,      PREVIOUS_CUSTOMER_TRX_LINE_ID
,      QUANTITY_CREDITED
,      UNIT_STANDARD_PRICE
,      SALES_ORDER_REVISION
,      SALES_ORDER_LINE
,      ACCOUNTING_RULE_ID
,      ACCOUNTING_RULE_DURATION
,      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
,      GLOBAL_ATTRIBUTE_CATEGORY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      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
,      WH_UPDATE_DATE
FROM APPS.AR_INVOICE_LINES_V;

Dependencies

[top of page]

APPS.AR_INVOICE_LINES_V references the following:

APPS: AR_INVOICE_SQL_FUNC_PUB - show dependent code; AR_MEMO_LINES; AR_VAT_TAX_VL; MO_GLOBAL - show dependent code; MTL_SYSTEM_ITEMS; MTL_UNITS_OF_MEASURE; RA_CUSTOMER_TRX; RA_CUSTOMER_TRX_LINES; RA_CUST_TRX_TYPES; RA_TAX_EXEMPTIONS

APPS.AR_INVOICE_LINES_V is referenced by following:

APPS: IBY_AR_UTILS - show dependent code; IBY_AR_UTILS - show dependent code