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.CLN_3C3_INVOICE_LINE_V

Object Details

Object Name:	CLN_3C3_INVOICE_LINE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CLN.CLN_3C3_INVOICE_LINE_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_TRX_ID	NUMBER	(15)	Yes	Customer Transaction ID
CUSTOMER_TRX_LINE_ID	NUMBER	(15)	Yes	Customer Transaction Line ID
LINE_TYPE	VARCHAR2	(20)	Yes	Line Type
LINE_NUMBER	NUMBER		Yes	Line Number
LINE_AMOUNT	NUMBER		Yes	Line Amount
UNIT_SELLING_PRICE	NUMBER			Unit Selling Price
QUANTITY	NUMBER			Quantity
DESCRIPTION	VARCHAR2	(240)		Description
UOM	VARCHAR2	(3)		Unit of Mesure
ITEM	VARCHAR2	(4000)		Item
ITEM_DESCRIPTION	VARCHAR2	(240)		Item Description
REFERENCE_NUMBER	VARCHAR2	(82)		Reference Number
SALES_ORDER_NUMBER	VARCHAR2	(50)
SALES_ORDER_REVISION	NUMBER
SALES_ORDER_LINE_NUMBER	VARCHAR2	(30)

Query Text

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


SELECT CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      LINE_TYPE
,      LINE_NUMBER
,      LINE_AMOUNT
,      UNIT_SELLING_PRICE
,      QUANTITY
,      DESCRIPTION
,      UOM
,      ITEM
,      ITEM_DESCRIPTION
,      REFERENCE_NUMBER
,      SALES_ORDER_NUMBER
,      SALES_ORDER_REVISION
,      SALES_ORDER_LINE_NUMBER
FROM APPS.CLN_3C3_INVOICE_LINE_V;

Dependencies

[top of page]

APPS.CLN_3C3_INVOICE_LINE_V references the following:

APPS: AR_MEMO_LINES_ALL_VL; FA_RX_FLEX_PKG - show dependent code; MTL_SYSTEM_ITEMS; RA_CUSTOMER_TRX_LINES_ALL

APPS.CLN_3C3_INVOICE_LINE_V is not referenced by any database object