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]

TYPE: SYSTEM.ASO_LINE_TYPE

Object Details

Object Name:	ASO_LINE_TYPE
Object Type:	TYPE
Owner:	SYSTEM
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
ACCOUNTING_RULE_ID	NUMBER
ACTUAL_ARRIVAL_DATE	DATE
ACTUAL_SHIPMENT_DATE	DATE
AGREEMENT_ID	NUMBER
ARRIVAL_SET_ID	NUMBER
ATO_LINE_ID	NUMBER
ATTRIBUTE1	VARCHAR2	(240)
ATTRIBUTE10	VARCHAR2	(240)
ATTRIBUTE11	VARCHAR2	(240)
ATTRIBUTE12	VARCHAR2	(240)
ATTRIBUTE13	VARCHAR2	(240)
ATTRIBUTE14	VARCHAR2	(240)
ATTRIBUTE15	VARCHAR2	(240)
ATTRIBUTE2	VARCHAR2	(240)
ATTRIBUTE3	VARCHAR2	(240)
ATTRIBUTE4	VARCHAR2	(240)
ATTRIBUTE5	VARCHAR2	(240)
ATTRIBUTE6	VARCHAR2	(240)
ATTRIBUTE7	VARCHAR2	(240)
ATTRIBUTE8	VARCHAR2	(240)
ATTRIBUTE9	VARCHAR2	(240)
AUTHORIZED_TO_SHIP_FLAG	VARCHAR2	(1)
AUTO_SELECTED_QUANTITY	NUMBER
BOOKED_FLAG	VARCHAR2	(1)
CANCELLED_FLAG	VARCHAR2	(1)
CANCELLED_QUANTITY	NUMBER
COMMITMENT_ID	NUMBER
COMPONENT_CODE	VARCHAR2	(1000)
COMPONENT_NUMBER	NUMBER
COMPONENT_SEQUENCE_ID	NUMBER
CONFIG_HEADER_ID	NUMBER
CONFIG_REV_NBR	NUMBER
CONFIG_DISPLAY_SEQUENCE	NUMBER
CONFIGURATION_ID	NUMBER
CONTEXT	VARCHAR2	(30)
CREATED_BY	NUMBER
CREATION_DATE	DATE
CREDIT_INVOICE_LINE_ID	NUMBER
CUSTOMER_DOCK_CODE	VARCHAR2	(50)
CUSTOMER_JOB	VARCHAR2	(50)
CUSTOMER_PRODUCTION_LINE	VARCHAR2	(50)
CUSTOMER_TRX_LINE_ID	NUMBER
CUST_MODEL_SERIAL_NUMBER	VARCHAR2	(50)
CUST_PO_NUMBER	VARCHAR2	(50)
CUST_PRODUCTION_SEQ_NUM	VARCHAR2	(50)
DELIVERY_LEAD_TIME	NUMBER
DELIVER_TO_CONTACT_ID	NUMBER
DELIVER_TO_ORG_ID	NUMBER
DEMAND_BUCKET_TYPE_CODE	VARCHAR2	(30)
DEMAND_CLASS_CODE	VARCHAR2	(30)
DEP_PLAN_REQUIRED_FLAG	VARCHAR2	(1)
EARLIEST_ACCEPTABLE_DATE	DATE
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)
EXPLOSION_DATE	DATE
FOB_POINT_CODE	VARCHAR2	(30)
FREIGHT_CARRIER_CODE	VARCHAR2	(30)
FREIGHT_TERMS_CODE	VARCHAR2	(30)
FULFILLED_QUANTITY	NUMBER
GLOBAL_ATTRIBUTE1	VARCHAR2	(240)
GLOBAL_ATTRIBUTE10	VARCHAR2	(240)
GLOBAL_ATTRIBUTE11	VARCHAR2	(240)
GLOBAL_ATTRIBUTE12	VARCHAR2	(240)
GLOBAL_ATTRIBUTE13	VARCHAR2	(240)
GLOBAL_ATTRIBUTE14	VARCHAR2	(240)
GLOBAL_ATTRIBUTE15	VARCHAR2	(240)
GLOBAL_ATTRIBUTE16	VARCHAR2	(240)
GLOBAL_ATTRIBUTE17	VARCHAR2	(240)
GLOBAL_ATTRIBUTE18	VARCHAR2	(240)
GLOBAL_ATTRIBUTE19	VARCHAR2	(240)
GLOBAL_ATTRIBUTE2	VARCHAR2	(240)
GLOBAL_ATTRIBUTE20	VARCHAR2	(240)
GLOBAL_ATTRIBUTE3	VARCHAR2	(240)
GLOBAL_ATTRIBUTE4	VARCHAR2	(240)
GLOBAL_ATTRIBUTE5	VARCHAR2	(240)
GLOBAL_ATTRIBUTE6	VARCHAR2	(240)
GLOBAL_ATTRIBUTE7	VARCHAR2	(240)
GLOBAL_ATTRIBUTE8	VARCHAR2	(240)
GLOBAL_ATTRIBUTE9	VARCHAR2	(240)
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
HEADER_ID	NUMBER
INDUSTRY_ATTRIBUTE1	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE10	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE11	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE12	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE13	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE14	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE15	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE16	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE17	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE18	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE19	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE20	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE21	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE22	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE23	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE24	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE25	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE26	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE27	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE28	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE29	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE30	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE2	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE3	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE4	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE5	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE6	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE7	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE8	VARCHAR2	(240)
INDUSTRY_ATTRIBUTE9	VARCHAR2	(240)
INDUSTRY_CONTEXT	VARCHAR2	(30)
TP_CONTEXT	VARCHAR2	(30)
TP_ATTRIBUTE1	VARCHAR2	(240)
TP_ATTRIBUTE2	VARCHAR2	(240)
TP_ATTRIBUTE3	VARCHAR2	(240)
TP_ATTRIBUTE4	VARCHAR2	(240)
TP_ATTRIBUTE5	VARCHAR2	(240)
TP_ATTRIBUTE6	VARCHAR2	(240)
TP_ATTRIBUTE7	VARCHAR2	(240)
TP_ATTRIBUTE8	VARCHAR2	(240)
TP_ATTRIBUTE9	VARCHAR2	(240)
TP_ATTRIBUTE10	VARCHAR2	(240)
TP_ATTRIBUTE11	VARCHAR2	(240)
TP_ATTRIBUTE12	VARCHAR2	(240)
TP_ATTRIBUTE13	VARCHAR2	(240)
TP_ATTRIBUTE14	VARCHAR2	(240)
TP_ATTRIBUTE15	VARCHAR2	(240)
INTERMED_SHIP_TO_ORG_ID	NUMBER
INTERMED_SHIP_TO_CONTACT_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
INVOICE_INTERFACE_STATUS_CODE	VARCHAR2	(30)
INVOICE_TO_CONTACT_ID	NUMBER
INVOICE_TO_ORG_ID	NUMBER
INVOICING_RULE_ID	NUMBER
ORDERED_ITEM	VARCHAR2	(2000)
ITEM_REVISION	VARCHAR2	(3)
ITEM_TYPE_CODE	VARCHAR2	(30)
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER
LATEST_ACCEPTABLE_DATE	DATE
LINE_CATEGORY_CODE	VARCHAR2	(30)
LINE_ID	NUMBER
LINE_NUMBER	NUMBER
LINE_TYPE_ID	NUMBER
LINK_TO_LINE_REF	VARCHAR2	(50)
LINK_TO_LINE_ID	NUMBER
LINK_TO_LINE_INDEX	NUMBER
MODEL_GROUP_NUMBER	NUMBER
MFG_COMPONENT_SEQUENCE_ID	NUMBER
OPEN_FLAG	VARCHAR2	(1)
OPTION_FLAG	VARCHAR2	(1)
OPTION_NUMBER	NUMBER
ORDERED_QUANTITY	NUMBER
ORDER_QUANTITY_UOM	VARCHAR2	(3)
ORG_ID	NUMBER
ORIG_SYS_DOCUMENT_REF	VARCHAR2	(50)
ORIG_SYS_LINE_REF	VARCHAR2	(50)
OVER_SHIP_REASON_CODE	VARCHAR2	(30)
OVER_SHIP_RESOLVED_FLAG	VARCHAR2	(1)
PAYMENT_TERM_ID	NUMBER
PLANNING_PRIORITY	NUMBER
PRICE_LIST_ID	NUMBER
PRICING_ATTRIBUTE1	VARCHAR2	(240)
PRICING_ATTRIBUTE10	VARCHAR2	(240)
PRICING_ATTRIBUTE2	VARCHAR2	(240)
PRICING_ATTRIBUTE3	VARCHAR2	(240)
PRICING_ATTRIBUTE4	VARCHAR2	(240)
PRICING_ATTRIBUTE5	VARCHAR2	(240)
PRICING_ATTRIBUTE6	VARCHAR2	(240)
PRICING_ATTRIBUTE7	VARCHAR2	(240)
PRICING_ATTRIBUTE8	VARCHAR2	(240)
PRICING_ATTRIBUTE9	VARCHAR2	(240)
PRICING_CONTEXT	VARCHAR2	(240)
PRICING_DATE	DATE
PRICING_QUANTITY	NUMBER
PRICING_QUANTITY_UOM	VARCHAR2	(3)
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
PROJECT_ID	NUMBER
PROMISE_DATE	DATE
RE_SOURCE_FLAG	VARCHAR2	(1)
REFERENCE_CUSTOMER_TRX_LINE_ID	NUMBER
REFERENCE_HEADER_ID	NUMBER
REFERENCE_LINE_ID	NUMBER
REFERENCE_TYPE	VARCHAR2	(30)
REQUEST_DATE	DATE
REQUEST_ID	NUMBER
RESERVED_QUANTITY	NUMBER
RETURN_ATTRIBUTE1	VARCHAR2	(240)
RETURN_ATTRIBUTE10	VARCHAR2	(240)
RETURN_ATTRIBUTE11	VARCHAR2	(240)
RETURN_ATTRIBUTE12	VARCHAR2	(240)
RETURN_ATTRIBUTE13	VARCHAR2	(240)
RETURN_ATTRIBUTE14	VARCHAR2	(240)
RETURN_ATTRIBUTE15	VARCHAR2	(240)
RETURN_ATTRIBUTE2	VARCHAR2	(240)
RETURN_ATTRIBUTE3	VARCHAR2	(240)
RETURN_ATTRIBUTE4	VARCHAR2	(240)
RETURN_ATTRIBUTE5	VARCHAR2	(240)
RETURN_ATTRIBUTE6	VARCHAR2	(240)
RETURN_ATTRIBUTE7	VARCHAR2	(240)
RETURN_ATTRIBUTE8	VARCHAR2	(240)
RETURN_ATTRIBUTE9	VARCHAR2	(240)
RETURN_CONTEXT	VARCHAR2	(30)
RETURN_REASON_CODE	VARCHAR2	(30)
RLA_SCHEDULE_TYPE_CODE	VARCHAR2	(30)
SALESREP_ID	NUMBER
SCHEDULE_ARRIVAL_DATE	DATE
SCHEDULE_SHIP_DATE	DATE
SCHEDULE_ACTION_CODE	VARCHAR2	(30)
SCHEDULE_STATUS_CODE	VARCHAR2	(30)
SHIPMENT_NUMBER	NUMBER
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)
SHIPPED_QUANTITY	NUMBER
SHIPPING_INTERFACED_FLAG	VARCHAR2	(1)
SHIPPING_METHOD_CODE	VARCHAR2	(30)
SHIPPING_QUANTITY	NUMBER
SHIPPING_QUANTITY_UOM	VARCHAR2	(3)
SHIP_FROM_ORG_ID	NUMBER
SHIP_MODEL_COMPLETE_FLAG	VARCHAR2	(30)
SHIP_SET_ID	NUMBER
SHIP_TOLERANCE_ABOVE	NUMBER
SHIP_TOLERANCE_BELOW	NUMBER
SHIP_TO_CONTACT_ID	NUMBER
SHIP_TO_ORG_ID	NUMBER
SOLD_TO_ORG_ID	NUMBER
SOLD_FROM_ORG_ID	NUMBER
SORT_ORDER	VARCHAR2	(240)
SOURCE_DOCUMENT_ID	NUMBER
SOURCE_DOCUMENT_LINE_ID	NUMBER
SOURCE_DOCUMENT_TYPE_ID	NUMBER
SOURCE_TYPE_CODE	VARCHAR2	(30)
SPLIT_FROM_LINE_ID	NUMBER
TASK_ID	NUMBER
TAX_CODE	VARCHAR2	(50)
TAX_DATE	DATE
TAX_EXEMPT_FLAG	VARCHAR2	(30)
TAX_EXEMPT_NUMBER	VARCHAR2	(50)
TAX_EXEMPT_REASON_CODE	VARCHAR2	(30)
TAX_POINT_CODE	VARCHAR2	(30)
TAX_RATE	NUMBER
TAX_VALUE	NUMBER
TOP_MODEL_LINE_REF	VARCHAR2	(50)
TOP_MODEL_LINE_ID	NUMBER
TOP_MODEL_LINE_INDEX	NUMBER
UNIT_LIST_PRICE	NUMBER
UNIT_SELLING_PRICE	NUMBER
VEH_CUS_ITEM_CUM_KEY_ID	NUMBER
VISIBLE_DEMAND_FLAG	VARCHAR2	(1)
RETURN_STATUS	VARCHAR2	(1)
DB_FLAG	VARCHAR2	(1)
OPERATION	VARCHAR2	(30)
FIRST_ACK_CODE	VARCHAR2	(30)
FIRST_ACK_DATE	DATE
LAST_ACK_CODE	VARCHAR2	(30)
LAST_ACK_DATE	DATE
CHANGE_REASON	VARCHAR2	(30)
CHANGE_COMMENTS	VARCHAR2	(2000)
ARRIVAL_SET	VARCHAR2	(30)
SHIP_SET	VARCHAR2	(30)
ORDER_SOURCE_ID	NUMBER
ORIG_SYS_SHIPMENT_REF	VARCHAR2	(50)
CHANGE_SEQUENCE	VARCHAR2	(50)
CHANGE_REQUEST_CODE	VARCHAR2	(30)
STATUS_FLAG	VARCHAR2	(1)
DROP_SHIP_FLAG	VARCHAR2	(1)
CUSTOMER_LINE_NUMBER	VARCHAR2	(50)
CUSTOMER_SHIPMENT_NUMBER	VARCHAR2	(50)
CUSTOMER_ITEM_NET_PRICE	NUMBER
CUSTOMER_PAYMENT_TERM_ID	NUMBER
ORDERED_ITEM_ID	NUMBER
ITEM_IDENTIFIER_TYPE	VARCHAR2	(25)
SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)
PACKING_INSTRUCTIONS	VARCHAR2	(2000)
CALCULATE_PRICE_FLAG	VARCHAR2	(1)
INVOICED_QUANTITY	NUMBER
SERVICE_TXN_REASON_CODE	VARCHAR2	(30)
SERVICE_TXN_COMMENTS	VARCHAR2	(2000)
SERVICE_DURATION	NUMBER
SERVICE_PERIOD	VARCHAR2	(3)
SERVICE_START_DATE	DATE
SERVICE_END_DATE	DATE
SERVICE_COTERMINATE_FLAG	VARCHAR2	(1)
UNIT_LIST_PERCENT	NUMBER
UNIT_SELLING_PERCENT	NUMBER
UNIT_PERCENT_BASE_PRICE	NUMBER
SERVICE_NUMBER	NUMBER
SERVICE_REFERENCE_TYPE_CODE	VARCHAR2	(30)
SERVICE_REFERENCE_LINE_ID	NUMBER
SERVICE_REFERENCE_SYSTEM_ID	NUMBER
SERVICE_REF_ORDER_NUMBER	NUMBER
SERVICE_REF_LINE_NUMBER	NUMBER
SERVICE_REF_SHIPMENT_NUMBER	NUMBER
SERVICE_REF_OPTION_NUMBER	NUMBER
SERVICE_LINE_INDEX	NUMBER
LINE_SET_ID	NUMBER
SPLIT_BY	VARCHAR2	(240)
SPLIT_ACTION_CODE	VARCHAR2	(30)
SHIPPABLE_FLAG	VARCHAR2	(1)
MODEL_REMNANT_FLAG	VARCHAR2	(1)
FLOW_STATUS_CODE	VARCHAR2	(30)
FULFILLED_FLAG	VARCHAR2	(1)
FULFILLMENT_METHOD_CODE	VARCHAR2	(30)
SEMI_PROCESSED_FLAG	VARCHAR2	(3)

Dependencies

[top of page]

SYSTEM.ASO_LINE_TYPE references the following:

SYS: STANDARD - show dependent code

SYSTEM.ASO_LINE_TYPE is referenced by following:

APPS: ASO_ORDER_FEEDBACK_GET_PVT - show dependent code; ASO_ORDER_FEEDBACK_UPDATE_PVT - show dependent code
SYSTEM: ASO_LINE_VAR_TYPE