[Home] [Help] [Dependency Information]
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 |
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) |
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;
APPS.CLN_3C3_INVOICE_LINE_V is not referenced by any database object
|
|
|