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.OE_PRN_ORDER_HEADERS_V

Object Details

Object Name:	OE_PRN_ORDER_HEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_PRN_ORDER_HEADERS_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
HEADER_ID	NUMBER		Yes	Order Header Identifier
ORG_ID	NUMBER			Operating Unit which performed this transaction
ORDER_NUMBER	NUMBER		Yes	User-visible number of the order
VERSION_NUMBER	NUMBER		Yes	Not Used
SOURCE_DOCUMENT_TYPE_ID	NUMBER			Indicates the source of the order
SOURCE_DOCUMENT_ID	NUMBER			Source Order Header Identifier
ORDER_SOURCE_ID	NUMBER			Source of the order
ORIG_SYS_DOCUMENT_REF	VARCHAR2	(50)		Original document reference for the order in external system
ORDERED_DATE	DATE			Ordered Date
REQUEST_DATE	DATE			Request date for the order
TAX_EXEMPT_NUMBER	VARCHAR2	(80)		The Tax exemption Number
CUST_PO_NUMBER	VARCHAR2	(50)		Customer Purchase Order Number
SHIPPING_METHOD_CODE	VARCHAR2	(30)		Shipping method to be used to ship the order
SOLD_TO_ORG_ID	NUMBER			Sold to customer
SHIP_TO_ORG_ID	NUMBER			Ship to Organization Id
INVOICE_TO_ORG_ID	NUMBER			Invoice To Organization ID
DELIVER_TO_ORG_ID	NUMBER			Deliver to Organization Id
SOLD_TO_CONTACT_ID	NUMBER			Customer contact
SHIP_TO_CONTACT_ID	NUMBER			Ship to Contact Id
INVOICE_TO_CONTACT_ID	NUMBER			Invoice To Contact ID
DELIVER_TO_CONTACT_ID	NUMBER			Deliver to Contact Id
SALESREP_ID	NUMBER	(15)		Sales representative Identification
SOLD_FROM_ORG_ID	NUMBER			Selling Organization
SHIP_FROM_ORG_ID	NUMBER			Ship From Organization Id - Warehouse
SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)		Shipping Instructions for Order
PACKING_INSTRUCTIONS	VARCHAR2	(2000)		Packing Instructions for Order
TRANSACTIONAL_CURR_NAME	VARCHAR2	(80)
ORDER_TOTAL	VARCHAR2	(4000)
LINES_TOTAL	VARCHAR2	(4000)
CHARGES_TOTAL	VARCHAR2	(4000)
TAXES_TOTAL	VARCHAR2	(4000)
AGREEMENT_NAME	VARCHAR2	(240)
AGREEMENT_VERSION	VARCHAR2	(50)
BLANKET_NUMBER	NUMBER
BLANKET_VERSION_NUMBER	NUMBER
INVOICING_RULE_NAME	VARCHAR2	(30)
PAYMENT_TERMS	VARCHAR2	(15)

Query Text

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


SELECT HEADER_ID
,      ORG_ID
,      ORDER_NUMBER
,      VERSION_NUMBER
,      SOURCE_DOCUMENT_TYPE_ID
,      SOURCE_DOCUMENT_ID
,      ORDER_SOURCE_ID
,      ORIG_SYS_DOCUMENT_REF
,      ORDERED_DATE
,      REQUEST_DATE
,      TAX_EXEMPT_NUMBER
,      CUST_PO_NUMBER
,      SHIPPING_METHOD_CODE
,      SOLD_TO_ORG_ID
,      SHIP_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      DELIVER_TO_ORG_ID
,      SOLD_TO_CONTACT_ID
,      SHIP_TO_CONTACT_ID
,      INVOICE_TO_CONTACT_ID
,      DELIVER_TO_CONTACT_ID
,      SALESREP_ID
,      SOLD_FROM_ORG_ID
,      SHIP_FROM_ORG_ID
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      TRANSACTIONAL_CURR_NAME
,      ORDER_TOTAL
,      LINES_TOTAL
,      CHARGES_TOTAL
,      TAXES_TOTAL
,      AGREEMENT_NAME
,      AGREEMENT_VERSION
,      BLANKET_NUMBER
,      BLANKET_VERSION_NUMBER
,      INVOICING_RULE_NAME
,      PAYMENT_TERMS
FROM APPS.OE_PRN_ORDER_HEADERS_V;

Dependencies

[top of page]

APPS.OE_PRN_ORDER_HEADERS_V references the following:

APPS: FND_CURRENCIES_TL; FND_CURRENCY - show dependent code; OE_AGREEMENTS_TL; OE_BLANKET_HEADERS_ALL; OE_ORDER_HEADERS_ALL; OE_TOTALS_GRP - show dependent code; OE_TRANSACTION_TYPES_ALL; RA_RULES; RA_TERMS_TL

APPS.OE_PRN_ORDER_HEADERS_V is not referenced by any database object