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

VIEW: APPS.OKX_ORDER_HEADERS_V

Object Details
Object Name: OKX_ORDER_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_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
ID1 NUMBER
Yes
ID2 CHAR (1)
(Multi-part) Primary Key
NAME NUMBER
Yes Name
STATUS CHAR (1)
Status
DESCRIPTION VARCHAR2 (0)
Description
START_DATE_ACTIVE DATE

Date record becomes active
END_DATE_ACTIVE VARCHAR2 (0)
Date record becomes inactive
ORG_ID NUMBER


ORDER_NUMBER NUMBER
Yes
ORDER_TYPE_ID NUMBER
Yes
VERSION_NUMBER NUMBER
Yes
CREATION_DATE DATE
Yes Standard who column
EXPIRATION_DATE DATE


ORDER_SOURCE_ID NUMBER


ORDERED_DATE DATE


AGREEMENT_ID NUMBER


CUST_PO_NUMBER VARCHAR2 (50)

PAYMENT_TERM_ID NUMBER (15)

FREIGHT_CARRIER_CODE VARCHAR2 (30)

FOB_POINT_CODE VARCHAR2 (30)

FREIGHT_TERMS_CODE VARCHAR2 (30)

SHIP_TO_ORG_ID NUMBER


INVOICE_TO_ORG_ID NUMBER

Invoice To Organization ID
INVOICE_TO_CONTACT_ID NUMBER

Invoice To Contact ID
CANCELLED_FLAG VARCHAR2 (1)
Indicates whether order is cancelled ('Y') or not ('N')
OPEN_FLAG VARCHAR2 (1) Yes Indicates whether the order has been closed ('N') or not ('Y')
BOOKED_FLAG VARCHAR2 (1) Yes Indicates whether order is booked ('Y') or not ('N')
PAYMENT_TYPE_CODE VARCHAR2 (30)
Stores type of payment for orders (cash, check, credit)
ORDER_CATEGORY_CODE VARCHAR2 (30) Yes Order category code
SHIPPING_METHOD_CODE VARCHAR2 (30)

SHIPMENT_PRIORITY_CODE VARCHAR2 (30)

REQUEST_DATE DATE


RETURN_REASON_CODE VARCHAR2 (30)
This column stores return reason code for a return order, and is for defaulting to a return line
PAYMENT_AMOUNT NUMBER

Stores amount of payment
PRICE_LIST_ID NUMBER


TRANSACTIONAL_CURR_CODE VARCHAR2 (15)

INVOICING_RULE_ID NUMBER (15)
Invoicing rule used by AR for generating Invoice
ACCOUNTING_RULE_ID NUMBER (15)
Accounting rule used by AR for generating Invoice
SOLD_TO_ORG_ID NUMBER


SOLD_TO_CONTACT_ID NUMBER


DELIVER_TO_CONTACT_ID NUMBER


TAX_EXEMPT_NUMBER VARCHAR2 (80)
The Tax exemption Number
TAX_EXEMPT_FLAG VARCHAR2 (1)
It will decide the tax handling for the order. Possible values can be S - Standard, E - Exempt, R - Required
CONVERSION_RATE NUMBER

Rate of the currency conversion
CONVERSION_TYPE_CODE VARCHAR2 (30)
Currency Conversion type
CONVERSION_RATE_DATE DATE

Date of the currency conversion
SALESREP_ID NUMBER (15)
BOOKED_DATE DATE

PRICING_DATE DATE

TOTAL_AMOUNT NUMBER

FLOW_STATUS_CODE VARCHAR2 (30)
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      STATUS
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ORG_ID
,      ORDER_NUMBER
,      ORDER_TYPE_ID
,      VERSION_NUMBER
,      CREATION_DATE
,      EXPIRATION_DATE
,      ORDER_SOURCE_ID
,      ORDERED_DATE
,      AGREEMENT_ID
,      CUST_PO_NUMBER
,      PAYMENT_TERM_ID
,      FREIGHT_CARRIER_CODE
,      FOB_POINT_CODE
,      FREIGHT_TERMS_CODE
,      SHIP_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      INVOICE_TO_CONTACT_ID
,      CANCELLED_FLAG
,      OPEN_FLAG
,      BOOKED_FLAG
,      PAYMENT_TYPE_CODE
,      ORDER_CATEGORY_CODE
,      SHIPPING_METHOD_CODE
,      SHIPMENT_PRIORITY_CODE
,      REQUEST_DATE
,      RETURN_REASON_CODE
,      PAYMENT_AMOUNT
,      PRICE_LIST_ID
,      TRANSACTIONAL_CURR_CODE
,      INVOICING_RULE_ID
,      ACCOUNTING_RULE_ID
,      SOLD_TO_ORG_ID
,      SOLD_TO_CONTACT_ID
,      DELIVER_TO_CONTACT_ID
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_FLAG
,      CONVERSION_RATE
,      CONVERSION_TYPE_CODE
,      CONVERSION_RATE_DATE
,      SALESREP_ID
,      BOOKED_DATE
,      PRICING_DATE
,      TOTAL_AMOUNT
,      FLOW_STATUS_CODE
FROM APPS.OKX_ORDER_HEADERS_V;

Dependencies

[top of page]

APPS.OKX_ORDER_HEADERS_V references the following:

SchemaAPPS
PL/SQL PackageASO_ORDER_INT - show dependent code
SynonymOE_ORDER_HEADERS_ALL
APPS.OKX_ORDER_HEADERS_V is referenced by following:

SchemaAPPS
PL/SQL PackageOKC_OC_INT_CONFIG_PVT - show dependent code
PL/SQL PackageOKC_OC_INT_KTO_PVT - show dependent code
Package BodyOKC_OC_INT_KTO_PVT - show dependent code
PL/SQL PackageOKC_OC_INT_PRICING_PVT - show dependent code
Package BodyOKC_OC_INT_PRICING_PVT - show dependent code
PL/SQL PackageOKC_OC_INT_PUB - show dependent code
Package BodyOKC_OC_INT_PUB - show dependent code
PL/SQL PackageOKC_OC_INT_QTK_PVT - show dependent code
Package BodyOKC_OC_INT_SALESCDT_PVT - show dependent code
PL/SQL PackageOKC_OC_INT_SALESCDT_PVT - show dependent code
ViewOKC_REL_OBJ_ORDER_HEADERS_V
Package BodyOKS_CODE_HOOK - show dependent code
Package BodyOKS_ENTITLEMENTS_WEB - show dependent code
Package BodyOKS_KTO_INSREL_PUB - show dependent code
Package BodyOKS_KTO_INT_PUB - show dependent code
PL/SQL PackageOKS_KTO_INT_PUB - show dependent code
PL/SQL PackageOKS_OC_INT_KTO_PVT - show dependent code
Package BodyOKS_OC_INT_KTO_PVT - show dependent code
ViewOKS_ORDER_V
ViewOKS_VRM_HEADERS_V
ViewOKS_VRM_LINES_V