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]

VIEW: APPS.JTM_OE_ORDER_LINES_ALL_V

Object Details

Object Name:	JTM_OE_ORDER_LINES_ALL_V
Object Type:	VIEW
Owner:	APPS
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 Source]

Columns

Name	Datatype	Length	Mandatory
ACCESS_ID	NUMBER
LINE_ID	NUMBER		Yes
ORG_ID	NUMBER
HEADER_ID	NUMBER		Yes
LINE_TYPE_ID	NUMBER		Yes
LINE_NUMBER	NUMBER		Yes
ORDERED_ITEM	VARCHAR2	(2000)
REQUEST_DATE	DATE
PROMISE_DATE	DATE
SCHEDULE_SHIP_DATE	DATE
ORDER_QUANTITY_UOM	VARCHAR2	(3)
PRICING_QUANTITY	NUMBER
PRICING_QUANTITY_UOM	VARCHAR2	(3)
CANCELLED_QUANTITY	NUMBER
SHIPPED_QUANTITY	NUMBER
ORDERED_QUANTITY	NUMBER
FULFILLED_QUANTITY	NUMBER
SHIPPING_QUANTITY	NUMBER
SHIPPING_QUANTITY_UOM	VARCHAR2	(3)
DELIVERY_LEAD_TIME	NUMBER
SHIP_FROM_ORG_ID	NUMBER
SHIP_TO_ORG_ID	NUMBER
CUST_PO_NUMBER	VARCHAR2	(50)
PROJECT_ID	NUMBER
TASK_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER		Yes
SHIPMENT_NUMBER	NUMBER		Yes
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)
SHIPPING_METHOD_CODE	VARCHAR2	(30)
SOURCE_DOCUMENT_TYPE_ID	NUMBER
SOURCE_DOCUMENT_ID	NUMBER
SOURCE_DOCUMENT_LINE_ID	NUMBER
REFERENCE_LINE_ID	NUMBER
REFERENCE_TYPE	VARCHAR2	(30)
REFERENCE_HEADER_ID	NUMBER
ITEM_REVISION	VARCHAR2	(3)
REQUEST_ID	NUMBER
SORT_ORDER	VARCHAR2	(2000)
ITEM_TYPE_CODE	VARCHAR2	(30)
LINE_CATEGORY_CODE	VARCHAR2	(30)	Yes
ACTUAL_ARRIVAL_DATE	DATE
EARLIEST_ACCEPTABLE_DATE	DATE
LATEST_ACCEPTABLE_DATE	DATE
SCHEDULE_ARRIVAL_DATE	DATE
SCHEDULE_STATUS_CODE	VARCHAR2	(30)
SOURCE_TYPE_CODE	VARCHAR2	(30)
CANCELLED_FLAG	VARCHAR2	(1)
OPEN_FLAG	VARCHAR2	(1)	Yes
BOOKED_FLAG	VARCHAR2	(1)	Yes
RETURN_REASON_CODE	VARCHAR2	(30)
ORDERED_ITEM_ID	NUMBER
SHIPPING_INTERFACED_FLAG	VARCHAR2	(1)
PLANNING_PRIORITY	NUMBER
ORDER_SOURCE_ID	NUMBER
DROP_SHIP_FLAG	VARCHAR2	(1)
CONFIG_HEADER_ID	NUMBER
SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)
PACKING_INSTRUCTIONS	VARCHAR2	(2000)
INVOICED_QUANTITY	NUMBER
SHIPPABLE_FLAG	VARCHAR2	(1)
FLOW_STATUS_CODE	VARCHAR2	(30)
ORDERED_QUANTITY2	NUMBER
ORDERED_QUANTITY_UOM2	VARCHAR2	(3)
SHIPPING_QUANTITY2	NUMBER
CANCELLED_QUANTITY2	NUMBER
SHIPPED_QUANTITY2	NUMBER
SHIPPING_QUANTITY_UOM2	VARCHAR2	(3)
FULFILLED_QUANTITY2	NUMBER
LOCK_CONTROL	NUMBER
SUBINVENTORY	VARCHAR2	(10)
ORDER_STATUS	VARCHAR2	(80)

Query Text

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


SELECT ACCESS_ID
,      LINE_ID
,      ORG_ID
,      HEADER_ID
,      LINE_TYPE_ID
,      LINE_NUMBER
,      ORDERED_ITEM
,      REQUEST_DATE
,      PROMISE_DATE
,      SCHEDULE_SHIP_DATE
,      ORDER_QUANTITY_UOM
,      PRICING_QUANTITY
,      PRICING_QUANTITY_UOM
,      CANCELLED_QUANTITY
,      SHIPPED_QUANTITY
,      ORDERED_QUANTITY
,      FULFILLED_QUANTITY
,      SHIPPING_QUANTITY
,      SHIPPING_QUANTITY_UOM
,      DELIVERY_LEAD_TIME
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      CUST_PO_NUMBER
,      PROJECT_ID
,      TASK_ID
,      INVENTORY_ITEM_ID
,      SHIPMENT_NUMBER
,      SHIPMENT_PRIORITY_CODE
,      SHIPPING_METHOD_CODE
,      SOURCE_DOCUMENT_TYPE_ID
,      SOURCE_DOCUMENT_ID
,      SOURCE_DOCUMENT_LINE_ID
,      REFERENCE_LINE_ID
,      REFERENCE_TYPE
,      REFERENCE_HEADER_ID
,      ITEM_REVISION
,      REQUEST_ID
,      SORT_ORDER
,      ITEM_TYPE_CODE
,      LINE_CATEGORY_CODE
,      ACTUAL_ARRIVAL_DATE
,      EARLIEST_ACCEPTABLE_DATE
,      LATEST_ACCEPTABLE_DATE
,      SCHEDULE_ARRIVAL_DATE
,      SCHEDULE_STATUS_CODE
,      SOURCE_TYPE_CODE
,      CANCELLED_FLAG
,      OPEN_FLAG
,      BOOKED_FLAG
,      RETURN_REASON_CODE
,      ORDERED_ITEM_ID
,      SHIPPING_INTERFACED_FLAG
,      PLANNING_PRIORITY
,      ORDER_SOURCE_ID
,      DROP_SHIP_FLAG
,      CONFIG_HEADER_ID
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      INVOICED_QUANTITY
,      SHIPPABLE_FLAG
,      FLOW_STATUS_CODE
,      ORDERED_QUANTITY2
,      ORDERED_QUANTITY_UOM2
,      SHIPPING_QUANTITY2
,      CANCELLED_QUANTITY2
,      SHIPPED_QUANTITY2
,      SHIPPING_QUANTITY_UOM2
,      FULFILLED_QUANTITY2
,      LOCK_CONTROL
,      SUBINVENTORY
,      ORDER_STATUS
FROM APPS.JTM_OE_ORDER_LINES_ALL_V;

Dependencies

[top of page]

APPS.JTM_OE_ORDER_LINES_ALL_V references the following:

APPS: ASG_BASE - show dependent code; JTM_OE_ORDER_LINES_ALL_ACC; OE_LOOKUPS; OE_ORDER_LINES_ALL

APPS.JTM_OE_ORDER_LINES_ALL_V is not referenced by any database object