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_HEADERS_ALL_V

Object Details

Object Name:	JTM_OE_ORDER_HEADERS_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
HEADER_ID	NUMBER		Yes
ORG_ID	NUMBER
ORDER_TYPE_ID	NUMBER		Yes
ORDER_NUMBER	NUMBER		Yes
VERSION_NUMBER	NUMBER		Yes
EXPIRATION_DATE	DATE
ORDER_SOURCE_ID	NUMBER
SOURCE_DOCUMENT_TYPE_ID	NUMBER
SOURCE_DOCUMENT_ID	NUMBER
ORDERED_DATE	DATE
REQUEST_DATE	DATE
PRICING_DATE	DATE
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)
PARTIAL_SHIPMENTS_ALLOWED	VARCHAR2	(1)
CUST_PO_NUMBER	VARCHAR2	(50)
SHIPPING_METHOD_CODE	VARCHAR2	(30)
FREIGHT_CARRIER_CODE	VARCHAR2	(30)
SHIP_FROM_ORG_ID	NUMBER
SHIP_TO_ORG_ID	NUMBER
REQUEST_ID	NUMBER
CANCELLED_FLAG	VARCHAR2	(1)
OPEN_FLAG	VARCHAR2	(1)	Yes
BOOKED_FLAG	VARCHAR2	(1)	Yes
RETURN_REASON_CODE	VARCHAR2	(30)
EARLIEST_SCHEDULE_LIMIT	NUMBER
LATEST_SCHEDULE_LIMIT	NUMBER
ORDER_CATEGORY_CODE	VARCHAR2	(30)	Yes
SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)
PACKING_INSTRUCTIONS	VARCHAR2	(2000)
FLOW_STATUS_CODE	VARCHAR2	(30)
BOOKED_DATE	DATE
LOCK_CONTROL	NUMBER

Query Text

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


SELECT ACCESS_ID
,      HEADER_ID
,      ORG_ID
,      ORDER_TYPE_ID
,      ORDER_NUMBER
,      VERSION_NUMBER
,      EXPIRATION_DATE
,      ORDER_SOURCE_ID
,      SOURCE_DOCUMENT_TYPE_ID
,      SOURCE_DOCUMENT_ID
,      ORDERED_DATE
,      REQUEST_DATE
,      PRICING_DATE
,      SHIPMENT_PRIORITY_CODE
,      PARTIAL_SHIPMENTS_ALLOWED
,      CUST_PO_NUMBER
,      SHIPPING_METHOD_CODE
,      FREIGHT_CARRIER_CODE
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      REQUEST_ID
,      CANCELLED_FLAG
,      OPEN_FLAG
,      BOOKED_FLAG
,      RETURN_REASON_CODE
,      EARLIEST_SCHEDULE_LIMIT
,      LATEST_SCHEDULE_LIMIT
,      ORDER_CATEGORY_CODE
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      FLOW_STATUS_CODE
,      BOOKED_DATE
,      LOCK_CONTROL
FROM APPS.JTM_OE_ORDER_HEADERS_ALL_V;

Dependencies

[top of page]

APPS.JTM_OE_ORDER_HEADERS_ALL_V references the following:

APPS: ASG_BASE - show dependent code; JTM_OE_ORDER_HEADERS_ALL_ACC; OE_ORDER_HEADERS_ALL

APPS.JTM_OE_ORDER_HEADERS_ALL_V is not referenced by any database object