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


VIEW: APPS.ECE_INO_LINE_V

Object Details
Object Name: ECE_INO_LINE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEC.ECE_INO_LINE_V
Subobject Name:
Status: VALID

View Type

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


This view extracts line information
for the outbound Invoice (810/INVOIC) transaction.

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15)
Transaction ID
LINE_NUMBER NUMBER

Line Number
SALES_ORDER_NUMBER VARCHAR2 (50)
Sales Order Number
SALES_ORDER_REVISION_NUMBER NUMBER

Sales Order Revision Number
SALES_ORDER_LINE_NUMBER VARCHAR2 (30)
Sales Order Line Number
SALES_ORDER_DATE DATE

Sales Order Date
SALES_CHANNEL VARCHAR2 (50)
Sales Channel
ITEM_ID NUMBER (15)
Item ID
CUSTOMER_ITEM_NUMBER VARCHAR2 (50)
Customer Item Number
CUSTOMER_ITEM_DESC VARCHAR2 (240)
Customer Item Description
ITEM_DESCRIPTION VARCHAR2 (240)
Part Description
UOM_CODE VARCHAR2 (3)
Unit of Measure Code
ORDERED_QUANTITY NUMBER

Ordered Quantity
QUANTITY NUMBER

Invoiced Quantity
UNIT_STANDARD_PRICE NUMBER

Unit Standard Price
UNIT_SELLING_PRICE NUMBER

Unit Selling Price
LINE_AMOUNT NUMBER

Line Amount
CREDIT_MEMO_REASON VARCHAR2 (30)
Credit Memo Reason
CREDITED_LINE_NUMBER NUMBER

Credited Line Number
SHIP_ORDER_STATUS_INT VARCHAR2 (30)
Ship Order Status (Internal)
TRANSACTION_REFERENCE_KEY VARCHAR2 (0)
Transaction Reference Key
INTERFACE_LINE_CATEGORY VARCHAR2 (30)
Interface Line Context
INTERFACE_LINE_ATTRIBUTE1 VARCHAR2 (150)
Interface Line Flexfield 1
INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 (150)
Interface Line Flexfield 2
INTERFACE_LINE_ATTRIBUTE3 VARCHAR2 (150)
Interface Line Flexfield 3
INTERFACE_LINE_ATTRIBUTE4 VARCHAR2 (150)
Interface Line Flexfield 4
INTERFACE_LINE_ATTRIBUTE5 VARCHAR2 (150)
Interface Line Flexfield 5
INTERFACE_LINE_ATTRIBUTE6 VARCHAR2 (150)
Interface Line Flexfield 6
INTERFACE_LINE_ATTRIBUTE7 VARCHAR2 (150)
Interface Line Flexfield 7
INTERFACE_LINE_ATTRIBUTE8 VARCHAR2 (150)
Interface Line Flexfield 8
INTERFACE_LINE_ATTRIBUTE9 VARCHAR2 (150)
Interface Line Flexfield 9
INTERFACE_LINE_ATTRIBUTE10 VARCHAR2 (150)
Interface Line Flexfield 10
INTERFACE_LINE_ATTRIBUTE11 VARCHAR2 (150)
Interface Line Flexfield 11
INTERFACE_LINE_ATTRIBUTE12 VARCHAR2 (150)
Interface Line Flexfield 12
INTERFACE_LINE_ATTRIBUTE13 VARCHAR2 (150)
Interface Line Flexfield 13
INTERFACE_LINE_ATTRIBUTE14 VARCHAR2 (150)
Interface Line Flexfield 14
INTERFACE_LINE_ATTRIBUTE15 VARCHAR2 (150)
Interface Line Flexfield 15
LINE_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Line Flexfield Context
LINE_ATTRIBUTE1 VARCHAR2 (150)
Line Flexfield 1
LINE_ATTRIBUTE2 VARCHAR2 (150)
Line Flexfield 2
LINE_ATTRIBUTE3 VARCHAR2 (150)
Line Flexfield 3
LINE_ATTRIBUTE4 VARCHAR2 (150)
Line Flexfield 4
LINE_ATTRIBUTE5 VARCHAR2 (150)
Line Flexfield 5
LINE_ATTRIBUTE6 VARCHAR2 (150)
Line Flexfield 6
LINE_ATTRIBUTE7 VARCHAR2 (150)
Line Flexfield 7
LINE_ATTRIBUTE8 VARCHAR2 (150)
Line Flexfield 8
LINE_ATTRIBUTE9 VARCHAR2 (150)
Line Flexfield 9
LINE_ATTRIBUTE10 VARCHAR2 (150)
Line Flexfield 10
LINE_ATTRIBUTE11 VARCHAR2 (150)
Line Flexfield 11
LINE_ATTRIBUTE12 VARCHAR2 (150)
Line Flexfield 12
LINE_ATTRIBUTE13 VARCHAR2 (150)
Line Flexfield 13
LINE_ATTRIBUTE14 VARCHAR2 (150)
Line Flexfield 14
LINE_ATTRIBUTE15 VARCHAR2 (150)
Line Flexfield 15
HEADER_TP_ATTRIBUTE1 VARCHAR2 (240)
Header TP Attribute 1
HEADER_TP_ATTRIBUTE2 VARCHAR2 (240)
Header TP Attribute 2
HEADER_TP_ATTRIBUTE3 VARCHAR2 (240)
Header TP Attribute 3
HEADER_TP_ATTRIBUTE4 VARCHAR2 (240)
Header TP Attribute 4
HEADER_TP_ATTRIBUTE5 VARCHAR2 (240)
Header TP Attribute 5
HEADER_TP_ATTRIBUTE6 VARCHAR2 (240)
Header TP Attribute 6
HEADER_TP_ATTRIBUTE7 VARCHAR2 (240)
Header TP Attribute 7
HEADER_TP_ATTRIBUTE8 VARCHAR2 (240)
Header TP Attribute 8
HEADER_TP_ATTRIBUTE9 VARCHAR2 (240)
Header TP Attribute 9
HEADER_TP_ATTRIBUTE10 VARCHAR2 (240)
Header TP Attribute 10
HEADER_TP_ATTRIBUTE11 VARCHAR2 (240)
Header TP Attribute 11
HEADER_TP_ATTRIBUTE12 VARCHAR2 (240)
Header TP Attribute 12
HEADER_TP_ATTRIBUTE13 VARCHAR2 (240)
Header TP Attribute 13
HEADER_TP_ATTRIBUTE14 VARCHAR2 (240)
Header TP Attribute 14
HEADER_TP_ATTRIBUTE15 VARCHAR2 (240)
Header TP Attribute 15
LINE_TP_ATTRIBUTE1 VARCHAR2 (240)
Line TP Attribute 1
LINE_TP_ATTRIBUTE2 VARCHAR2 (240)
Line TP Attribute 2
LINE_TP_ATTRIBUTE3 VARCHAR2 (240)
Line TP Attribute 3
LINE_TP_ATTRIBUTE4 VARCHAR2 (240)
Line TP Attribute 4
LINE_TP_ATTRIBUTE5 VARCHAR2 (240)
Line TP Attribute 5
LINE_TP_ATTRIBUTE6 VARCHAR2 (240)
Line TP Attribute 6
LINE_TP_ATTRIBUTE7 VARCHAR2 (240)
Line TP Attribute 7
LINE_TP_ATTRIBUTE8 VARCHAR2 (240)
Line TP Attribute 8
LINE_TP_ATTRIBUTE9 VARCHAR2 (240)
Line TP Attribute 9
LINE_TP_ATTRIBUTE10 VARCHAR2 (240)
Line TP Attribute 10
LINE_TP_ATTRIBUTE11 VARCHAR2 (240)
Line TP Attribute 11
LINE_TP_ATTRIBUTE12 VARCHAR2 (240)
Line TP Attribute 12
LINE_TP_ATTRIBUTE13 VARCHAR2 (240)
Line TP Attribute 13
LINE_TP_ATTRIBUTE14 VARCHAR2 (240)
Line TP Attribute 14
LINE_TP_ATTRIBUTE15 VARCHAR2 (240)
Line TP Attribute 15
INDUSTRY_ATTRIBUTE1 VARCHAR2 (240)
Industry Attribute 1
INDUSTRY_ATTRIBUTE2 VARCHAR2 (240)
Industry Attribute 2
INDUSTRY_ATTRIBUTE3 VARCHAR2 (240)
Industry Attribute 3
INDUSTRY_ATTRIBUTE4 VARCHAR2 (240)
Industry Attribute 4
INDUSTRY_ATTRIBUTE5 VARCHAR2 (240)
Industry Attribute 5
INDUSTRY_ATTRIBUTE6 VARCHAR2 (240)
Industry Attribute 6
INDUSTRY_ATTRIBUTE7 VARCHAR2 (240)
Industry Attribute 7
INDUSTRY_ATTRIBUTE8 VARCHAR2 (240)
Industry Attribute 8
INDUSTRY_ATTRIBUTE9 VARCHAR2 (240)
Industry Attribute 9
INDUSTRY_ATTRIBUTE10 VARCHAR2 (240)
Industry Attribute 10
INDUSTRY_ATTRIBUTE11 VARCHAR2 (240)
Industry Attribute 11
INDUSTRY_ATTRIBUTE12 VARCHAR2 (240)
Industry Attribute 12
INDUSTRY_ATTRIBUTE13 VARCHAR2 (240)
Industry Attribute 13
INDUSTRY_ATTRIBUTE14 VARCHAR2 (240)
Industry Attribute 14
INDUSTRY_ATTRIBUTE15 VARCHAR2 (240)
Industry Attribute 15
INDUSTRY_CONTEXT VARCHAR2 (30)
Industry Context
ITEM_IDENTIFIER_TYPE VARCHAR2 (30)
Item Identifier Type (internal)
ORDERED_ITEM VARCHAR2 (2000)
Ordered Item
PURCHASE_ORDER_LINE_NUMBER VARCHAR2 (50)
Purchase Order Line Number
PURCHASE_ORDER_NUMBER VARCHAR2 (50)
Purchase Order Number
PURCHASE_ORDER_RELEASE_NUMBER VARCHAR2 (0)
Purchase Order Release Number
CUST_MODEL_SERIAL_NUMBER VARCHAR2 (50)
Customer Model Serial Number
SHIPPED_QUANTITY NUMBER

Shipped Quantity
INVOICE_LINE_TYPE VARCHAR2 (1)
Invoice Line Type
INVOICE_LINE_REFERENCE VARCHAR2 (40)
Invoice Line Reference
BILL_OF_LADING_NUMBER VARCHAR2 (150)
Bill Of Lading Number
GROSS_WEIGHT NUMBER

Delivery Gross Weight
NET_WEIGHT NUMBER

Delivery Net Weight
WEIGHT_UOM_CODE_INT VARCHAR2 (3)
Delivery Weight UOM Code (internal)
VOLUME NUMBER

Delivery Volume
VOLUME_UOM_CODE_INT VARCHAR2 (3)
Delivery Volume UOM Code (internal)
CUSTOMER_ITEM_ID NUMBER

Orders Customer Item ID
INVOICED_CUSTOMER_ITEM_ID VARCHAR2 (0)
Invoiced Customer Item ID
ORDERED_ITEM_ID NUMBER

Ordered Item Id
BOOKING_NUMBER VARCHAR2 (30)
Booking Number
PACKING_SLIP_NUMBER VARCHAR2 (50)
Packing Slip Number
DELIVERY_ID NUMBER

Delivery ID
SHIPMENT_NUMBER NUMBER

Shipment Number
WAREHOUSE_NAME VARCHAR2 (240)
Warehouse Name
WAREHOUSE_ADDRESS1 VARCHAR2 (240)
Warehouse Address Line 1
WAREHOUSE_ADDRESS2 VARCHAR2 (240)
Warehouse Address Line 2
WAREHOUSE_ADDRESS3 VARCHAR2 (240)
Warehouse Address Line 3
WAREHOUSE_CITY VARCHAR2 (30)
Warehouse City
WAREHOUSE_POSTAL_CODE VARCHAR2 (30)
Warehouse Postal Code
WAREHOUSE_COUNTRY VARCHAR2 (60)
Warehouse Country (Int)
WAREHOUSE_REGION_1 VARCHAR2 (120)
Warehouse Region 1(Int) (County)
WAREHOUSE_REGION_2 VARCHAR2 (120)
Warehouse Region 2(Int) (State)
WAREHOUSE_REGION_3 VARCHAR2 (120)
Warehouse Region 3 (Int)
FOB_LOCATION_CODE VARCHAR2 (60)
FOB Location (internal)
FREIGHT_TERMS_CODE VARCHAR2 (30)
Freight Terms Code(Internal)
ECE_TP_LOCATION_CODE VARCHAR2 (35)
Ship From EDI Location Code
WAREHOUSE_CODE VARCHAR2 (3)
Warehouse Code
SHIPPING_QUANTITY NUMBER

Shipping Quantity
SHIPPING_QUANTITY_UOM VARCHAR2 (3)
Shipping Quantity UOM(Internal)
SHIPPING_QUANTITY2 NUMBER

Shipping Quantity in secondary Shipping Unit of Measure
SHIPPED_QUANTITY2 NUMBER

Sipped Quantity In ordered_quantity_uom2
ORDERED_QUANTITY_UOM2 VARCHAR2 (3)
Ordered Unit Of Measure
Query Text

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


SELECT TRANSACTION_ID
,      LINE_NUMBER
,      SALES_ORDER_NUMBER
,      SALES_ORDER_REVISION_NUMBER
,      SALES_ORDER_LINE_NUMBER
,      SALES_ORDER_DATE
,      SALES_CHANNEL
,      ITEM_ID
,      CUSTOMER_ITEM_NUMBER
,      CUSTOMER_ITEM_DESC
,      ITEM_DESCRIPTION
,      UOM_CODE
,      ORDERED_QUANTITY
,      QUANTITY
,      UNIT_STANDARD_PRICE
,      UNIT_SELLING_PRICE
,      LINE_AMOUNT
,      CREDIT_MEMO_REASON
,      CREDITED_LINE_NUMBER
,      SHIP_ORDER_STATUS_INT
,      TRANSACTION_REFERENCE_KEY
,      INTERFACE_LINE_CATEGORY
,      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
,      LINE_ATTRIBUTE_CATEGORY
,      LINE_ATTRIBUTE1
,      LINE_ATTRIBUTE2
,      LINE_ATTRIBUTE3
,      LINE_ATTRIBUTE4
,      LINE_ATTRIBUTE5
,      LINE_ATTRIBUTE6
,      LINE_ATTRIBUTE7
,      LINE_ATTRIBUTE8
,      LINE_ATTRIBUTE9
,      LINE_ATTRIBUTE10
,      LINE_ATTRIBUTE11
,      LINE_ATTRIBUTE12
,      LINE_ATTRIBUTE13
,      LINE_ATTRIBUTE14
,      LINE_ATTRIBUTE15
,      HEADER_TP_ATTRIBUTE1
,      HEADER_TP_ATTRIBUTE2
,      HEADER_TP_ATTRIBUTE3
,      HEADER_TP_ATTRIBUTE4
,      HEADER_TP_ATTRIBUTE5
,      HEADER_TP_ATTRIBUTE6
,      HEADER_TP_ATTRIBUTE7
,      HEADER_TP_ATTRIBUTE8
,      HEADER_TP_ATTRIBUTE9
,      HEADER_TP_ATTRIBUTE10
,      HEADER_TP_ATTRIBUTE11
,      HEADER_TP_ATTRIBUTE12
,      HEADER_TP_ATTRIBUTE13
,      HEADER_TP_ATTRIBUTE14
,      HEADER_TP_ATTRIBUTE15
,      LINE_TP_ATTRIBUTE1
,      LINE_TP_ATTRIBUTE2
,      LINE_TP_ATTRIBUTE3
,      LINE_TP_ATTRIBUTE4
,      LINE_TP_ATTRIBUTE5
,      LINE_TP_ATTRIBUTE6
,      LINE_TP_ATTRIBUTE7
,      LINE_TP_ATTRIBUTE8
,      LINE_TP_ATTRIBUTE9
,      LINE_TP_ATTRIBUTE10
,      LINE_TP_ATTRIBUTE11
,      LINE_TP_ATTRIBUTE12
,      LINE_TP_ATTRIBUTE13
,      LINE_TP_ATTRIBUTE14
,      LINE_TP_ATTRIBUTE15
,      INDUSTRY_ATTRIBUTE1
,      INDUSTRY_ATTRIBUTE2
,      INDUSTRY_ATTRIBUTE3
,      INDUSTRY_ATTRIBUTE4
,      INDUSTRY_ATTRIBUTE5
,      INDUSTRY_ATTRIBUTE6
,      INDUSTRY_ATTRIBUTE7
,      INDUSTRY_ATTRIBUTE8
,      INDUSTRY_ATTRIBUTE9
,      INDUSTRY_ATTRIBUTE10
,      INDUSTRY_ATTRIBUTE11
,      INDUSTRY_ATTRIBUTE12
,      INDUSTRY_ATTRIBUTE13
,      INDUSTRY_ATTRIBUTE14
,      INDUSTRY_ATTRIBUTE15
,      INDUSTRY_CONTEXT
,      ITEM_IDENTIFIER_TYPE
,      ORDERED_ITEM
,      PURCHASE_ORDER_LINE_NUMBER
,      PURCHASE_ORDER_NUMBER
,      PURCHASE_ORDER_RELEASE_NUMBER
,      CUST_MODEL_SERIAL_NUMBER
,      SHIPPED_QUANTITY
,      INVOICE_LINE_TYPE
,      INVOICE_LINE_REFERENCE
,      BILL_OF_LADING_NUMBER
,      GROSS_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM_CODE_INT
,      VOLUME
,      VOLUME_UOM_CODE_INT
,      CUSTOMER_ITEM_ID
,      INVOICED_CUSTOMER_ITEM_ID
,      ORDERED_ITEM_ID
,      BOOKING_NUMBER
,      PACKING_SLIP_NUMBER
,      DELIVERY_ID
,      SHIPMENT_NUMBER
,      WAREHOUSE_NAME
,      WAREHOUSE_ADDRESS1
,      WAREHOUSE_ADDRESS2
,      WAREHOUSE_ADDRESS3
,      WAREHOUSE_CITY
,      WAREHOUSE_POSTAL_CODE
,      WAREHOUSE_COUNTRY
,      WAREHOUSE_REGION_1
,      WAREHOUSE_REGION_2
,      WAREHOUSE_REGION_3
,      FOB_LOCATION_CODE
,      FREIGHT_TERMS_CODE
,      ECE_TP_LOCATION_CODE
,      WAREHOUSE_CODE
,      SHIPPING_QUANTITY
,      SHIPPING_QUANTITY_UOM
,      SHIPPING_QUANTITY2
,      SHIPPED_QUANTITY2
,      ORDERED_QUANTITY_UOM2
FROM APPS.ECE_INO_LINE_V;

Dependencies

[top of page]

APPS.ECE_INO_LINE_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_LOCATIONS_ALL
SynonymMTL_CUSTOMER_ITEMS
SynonymMTL_PARAMETERS
SynonymOE_ORDER_HEADERS
SynonymOE_ORDER_LINES
SynonymOE_PRICE_ADJUSTMENTS
SynonymRA_CUSTOMER_TRX
SynonymRA_CUSTOMER_TRX_LINES
SynonymWSH_DELIVERY_LEGS
SynonymWSH_DOCUMENT_INSTANCES
SynonymWSH_NEW_DELIVERIES

APPS.ECE_INO_LINE_V is not referenced by any database object