[Home] [Help] [Dependency Information]
Object Name: | IBE_ORDER_DETAIL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IBE.IBE_ORDER_DETAIL_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_ID | NUMBER | Yes | Order System Generated Line Identifier. | |
HEADER_ID | NUMBER | Yes | Order Header Identifier | |
LINE_NUMBER | NUMBER | Yes | Line sequence number within the order | |
ORDER_QUANTITY_UOM | VARCHAR2 | (3) | Return order quantity Unit of measure | |
ORDERED_QUANTITY | NUMBER | Quantity ordered | ||
ITEM_NUMBER | VARCHAR2 | (40) | Part number of the item | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Product Description | |
BOM_ITEM_TYPE | NUMBER | Yes | Identifying the type of BOM Item | |
PRODUCT_DESCRIPTION | VARCHAR2 | (240) | Descriptive flexfield attribute | |
LICENSING_UNIT | VARCHAR2 | (40) | Flex field | |
PRICING_ATTRIBUTE10 | VARCHAR2 | (240) | ||
UNIT_SELLING_PRICE | NUMBER | Actual price charged to customer | ||
UNIT_LIST_PRICE | NUMBER | List price for the item | ||
TOTAL_LIST_PRICE | NUMBER | |||
EXTENDED_PRICE | NUMBER | Total order amount | ||
LINES_TOTAL | NUMBER | Total amount for all the line items | ||
UNIT_NET_PRICE | NUMBER | |||
TAXES_TOTAL | NUMBER | Total taxes for all the lines | ||
CHARGES_TOTAL | NUMBER | Total charges for all the lines | ||
SCHEDULE_SHIP_DATE | DATE | Date Scheduled to ship item | ||
SHIPPED_QUANTITY | NUMBER | Shipped Quantity | ||
CANCELLED_QUANTITY | NUMBER | Cancelled Quantity | ||
REQUEST_DATE | DATE | Ordered Item Request date | ||
LINE_CURRENCY_CODE | VARCHAR2 | (0) | Transaction currency for the line | |
ITEM_TYPE_CODE | VARCHAR2 | (30) | Type of item | |
TOP_MODEL_LINE_ID | NUMBER | System-generated identifier of configuration top parent line | ||
LINK_TO_LINE_ID | NUMBER | System-generated identifier of immediate parent component line | ||
ATO_LINE_ID | NUMBER | System-generated identifier if ATO | ||
PROMISE_DATE | DATE | Date promised to customer to receive item | ||
FLOW_STATUS_CODE | VARCHAR2 | (30) | Workflow status for the line | |
LINE_STATUS | VARCHAR2 | (80) | Yes | Meaning for Workflow status for the line from oe_lookups |
UOM_NAME | VARCHAR2 | (25) | Yes | Translation for Return order quantity Unit of measure |
SHIPMENT_NUMBER | NUMBER | Yes | System generated identifier of a shipment within a line | |
OPTION_NUMBER | NUMBER | System generated identifier for an option or a class within a model | ||
COMPONENT_NUMBER | NUMBER | System Generated Identifier of the included item within a model or a class | ||
SERVICE_NUMBER | NUMBER | Unique number to identify the service lines. | ||
SHIPPABLE_FLAG | VARCHAR2 | (1) | Flag to determine whether the item is shippable or not | |
LINE_RETURNABLE_FLAG | VARCHAR2 | (1) | Based on inventory attribute and the line status , determines whether the order line is returnable. (Y/N) | |
LINE_CATEGORY_CODE | VARCHAR2 | (30) | Yes | Indicates whether the line is regular(order) or return |
LINE_TYPE_DESC | VARCHAR2 | (30) | Yes | |
ORDER_CURR_CODE | VARCHAR2 | (15) | Transactional Currency Code | |
SERVICE_REFERENCE_TYPE_CODE | VARCHAR2 | (30) | To identify the service reference type. Typical values are Order and Customer Product | |
SERVICE_REFERENCE_LINE_ID | NUMBER | Identifies the immediate parent line to which the service is attached | ||
SERVICE_REFERENCE_SYSTEM_ID | NUMBER | To store system id for either reference type like order or customer product. | ||
CHARGE_PERIODICITY_CODE | VARCHAR2 | (3) | ||
CHARGE_PERIODICITY_DESC | VARCHAR2 | (25) | ||
MACD_LINE_FLAG | CHAR | (1) | ||
CONFIG_INSTANCE_NAME | VARCHAR2 | (255) | ||
CONTAINER_ITEM_FLAG | VARCHAR2 | (1) | ||
MODEL_CONTAINER_FLAG | VARCHAR2 | (1) | ||
CONFIG_DELTA_FLAG | NUMBER | |||
EXT_ACTIVATED_FLAG | VARCHAR2 | (1) | ||
ORG_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_ID
, HEADER_ID
, LINE_NUMBER
, ORDER_QUANTITY_UOM
, ORDERED_QUANTITY
, ITEM_NUMBER
, ITEM_DESCRIPTION
, BOM_ITEM_TYPE
, PRODUCT_DESCRIPTION
, LICENSING_UNIT
, PRICING_ATTRIBUTE10
, UNIT_SELLING_PRICE
, UNIT_LIST_PRICE
, TOTAL_LIST_PRICE
, EXTENDED_PRICE
, LINES_TOTAL
, UNIT_NET_PRICE
, TAXES_TOTAL
, CHARGES_TOTAL
, SCHEDULE_SHIP_DATE
, SHIPPED_QUANTITY
, CANCELLED_QUANTITY
, REQUEST_DATE
, LINE_CURRENCY_CODE
, ITEM_TYPE_CODE
, TOP_MODEL_LINE_ID
, LINK_TO_LINE_ID
, ATO_LINE_ID
, PROMISE_DATE
, FLOW_STATUS_CODE
, LINE_STATUS
, UOM_NAME
, SHIPMENT_NUMBER
, OPTION_NUMBER
, COMPONENT_NUMBER
, SERVICE_NUMBER
, SHIPPABLE_FLAG
, LINE_RETURNABLE_FLAG
, LINE_CATEGORY_CODE
, LINE_TYPE_DESC
, ORDER_CURR_CODE
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID
, CHARGE_PERIODICITY_CODE
, CHARGE_PERIODICITY_DESC
, MACD_LINE_FLAG
, CONFIG_INSTANCE_NAME
, CONTAINER_ITEM_FLAG
, MODEL_CONTAINER_FLAG
, CONFIG_DELTA_FLAG
, EXT_ACTIVATED_FLAG
, ORG_ID
FROM APPS.IBE_ORDER_DETAIL_V;
|
|
|