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


VIEW: APPS.IBE_RETURN_DETAIL_V

Object Details
Object Name: IBE_RETURN_DETAIL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIBE.IBE_RETURN_DETAIL_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER
Yes Return Order System Generated Line Identifier.
HEADER_ID NUMBER
Yes Return Order Header Identifier
ORDER_NUMBER NUMBER
Yes User-visible number of the Return order
LINE_NUMBER NUMBER
Yes Line sequence number within the order
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 configuration top model line
ORG_ID NUMBER

Operating Unit which performed this transaction
ORDER_CATEGORY_CODE VARCHAR2 (30) Yes Order Category Code like Order, Mixed or Return
LINE_CATEGORY_CODE VARCHAR2 (30) Yes Indicates whether the line is regular(order) or return
TRANSACTIONAL_CURR_CODE VARCHAR2 (15)
Currency for the order
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item ID
ITEM_TYPE_CODE VARCHAR2 (30)
Type of item. Ex: standard
ITEM_NUMBER VARCHAR2 (40)
Part number
ITEM_DESCRIPTION VARCHAR2 (240)
Product Description
BOM_ITEM_TYPE NUMBER
Yes Identifying the type of BOM Item
PRODUCT_DESCRIPTION VARCHAR2 (240)
Product Description
ORDER_QUANTITY_UOM VARCHAR2 (3)
Return order quantity Unit of measure
UOM_NAME VARCHAR2 (25) Yes Translation for Return order quantity Unit of measure
RETURNED_QUANTITY NUMBER

Return order quantity
ORDERED_QUANTITY NUMBER

Original order quantity
SHIPPED_QUANTITY NUMBER

Shipped Quantity
CANCELLED_QUANTITY NUMBER

Cancelled Quantity
UNIT_LIST_PRICE NUMBER

List price for the item
UNIT_SELLING_PRICE NUMBER

Actual price charged to customer
EXTENDED_PRICE NUMBER

Total order amount
LINES_TOTAL NUMBER

Total amount for all the items
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
REQUEST_DATE DATE

Ordered Item Request date
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
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.
CUST_ACCOUNT_ID NUMBER

Sold to Organization from order header
INVOICE_TO_CONTACT_ID NUMBER

Invoice To Contact ID
INVOICE_TO_ORG_ID NUMBER

Invoice To Organization ID
SHIP_TO_CONTACT_ID NUMBER

Ship to Contact Id
SHIP_TO_ORG_ID NUMBER

Ship to Organization Id
RETURN_CONTEXT VARCHAR2 (30)
Descriptive Flexfield segment (used to check what is the source for creation of return. Sales order/Invoice/PO)
SOURCE_ORDER_NUMBER NUMBER

Order Number from the original /referenced order
SOURCE_ORDER_ID VARCHAR2 (240)
Header Id of the original order
SOURCE_LINE_ID VARCHAR2 (240)
Line Id of the original order
SOURCE_ORDER_CATEGORY_CODE VARCHAR2 (30)
Order Category Code of Original order
INVENTORY_RETURNABLE_FLAG VARCHAR2 (1)
Inventory attribute to identify whether the item is returnable or not
RETURN_REASON_CODE VARCHAR2 (30)
This column stores return reason code for a return line, and is required for a return line
ORIG_ITEM_TYPE_CODE VARCHAR2 (30)
Type of item stated in the original order
ORIG_TOP_MODEL_LINE_ID NUMBER

Top model line id of the original order
ORIG_LINK_TO_LINE_ID NUMBER

Link to line id of the original order
ORDER_STATUS_CODE VARCHAR2 (30)
Flow status code of order header
Query Text

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


SELECT LINE_ID
,      HEADER_ID
,      ORDER_NUMBER
,      LINE_NUMBER
,      TOP_MODEL_LINE_ID
,      LINK_TO_LINE_ID
,      ATO_LINE_ID
,      ORG_ID
,      ORDER_CATEGORY_CODE
,      LINE_CATEGORY_CODE
,      TRANSACTIONAL_CURR_CODE
,      INVENTORY_ITEM_ID
,      ITEM_TYPE_CODE
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      BOM_ITEM_TYPE
,      PRODUCT_DESCRIPTION
,      ORDER_QUANTITY_UOM
,      UOM_NAME
,      RETURNED_QUANTITY
,      ORDERED_QUANTITY
,      SHIPPED_QUANTITY
,      CANCELLED_QUANTITY
,      UNIT_LIST_PRICE
,      UNIT_SELLING_PRICE
,      EXTENDED_PRICE
,      LINES_TOTAL
,      TAXES_TOTAL
,      CHARGES_TOTAL
,      SCHEDULE_SHIP_DATE
,      REQUEST_DATE
,      PROMISE_DATE
,      FLOW_STATUS_CODE
,      LINE_STATUS
,      SHIPMENT_NUMBER
,      OPTION_NUMBER
,      COMPONENT_NUMBER
,      SERVICE_NUMBER
,      CUST_ACCOUNT_ID
,      INVOICE_TO_CONTACT_ID
,      INVOICE_TO_ORG_ID
,      SHIP_TO_CONTACT_ID
,      SHIP_TO_ORG_ID
,      RETURN_CONTEXT
,      SOURCE_ORDER_NUMBER
,      SOURCE_ORDER_ID
,      SOURCE_LINE_ID
,      SOURCE_ORDER_CATEGORY_CODE
,      INVENTORY_RETURNABLE_FLAG
,      RETURN_REASON_CODE
,      ORIG_ITEM_TYPE_CODE
,      ORIG_TOP_MODEL_LINE_ID
,      ORIG_LINK_TO_LINE_ID
,      ORDER_STATUS_CODE
FROM APPS.IBE_RETURN_DETAIL_V;

Dependencies

[top of page]

APPS.IBE_RETURN_DETAIL_V references the following:

SchemaAPPS
ViewMTL_SYSTEM_ITEMS_VL
SynonymMTL_UNITS_OF_MEASURE_TL
ViewOE_LOOKUPS
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
PL/SQL PackageOE_PROFILE - show dependent code
PL/SQL PackageOE_TOTALS_GRP - show dependent code
APPS.IBE_RETURN_DETAIL_V is referenced by following:

SchemaAPPS
Package BodyIBE_WORKFLOW_PVT - show dependent code