[Home] [Help] [Dependency Information]
Object Name: | CSC_ORDER_HEADERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORDER_HEADER_ID | NUMBER | Yes | ||
CONT_REL_PARTY_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | |||
ORG_NAME | VARCHAR2 | (240) | ||
ORDER_NUMBER | NUMBER | Yes | ||
FLOW_STATUS_CODE | VARCHAR2 | (30) | ||
FLOW_STATUS | VARCHAR2 | (80) | ||
ORDER_TYPE_ID | NUMBER | Yes | ||
ORDER_TYPE | VARCHAR2 | (30) | Yes | |
ORDER_SOURCE_ID | NUMBER | |||
ORDER_SOURCE | VARCHAR2 | (240) | ||
CREATION_DATE | DATE | Yes | ||
TRANSACTIONAL_CURR_CODE | VARCHAR2 | (15) | ||
SOLD_TO_ORG_ID | NUMBER | |||
SOLD_TO_CONTACT_ID | NUMBER | |||
SOLD_TO_CONTACT | VARCHAR2 | (383) | ||
ACCOUNT_NUMBER | VARCHAR2 | (30) | ||
ACCOUNT_NAME | VARCHAR2 | (240) | ||
PARTY_ID | NUMBER | (15) | ||
SALESREP_NAME | VARCHAR2 | (240) | ||
SALESREP_ID | NUMBER | (15) | ||
SALES_CHANNEL_CODE | VARCHAR2 | (30) | ||
SALES_CHANNEL | VARCHAR2 | (80) | ||
ORDER_TOTAL | VARCHAR2 | (4000) | ||
OPEN_FLAG | VARCHAR2 | (1) | Yes | |
UNFORM_ORDER_TOTAL | NUMBER | Unformatted Order Total | ||
QUOTE_NUMBER | NUMBER | Quote Number | ||
QUOTE_DATE | DATE | Quote Date | ||
ORDER_NUMBER_DISP | NUMBER | Order Number - Used as display column | ||
ORDERED_DATE | DATE | Unformatted Order Total |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_HEADER_ID
, CONT_REL_PARTY_ID
, ORG_ID
, ORG_NAME
, ORDER_NUMBER
, FLOW_STATUS_CODE
, FLOW_STATUS
, ORDER_TYPE_ID
, ORDER_TYPE
, ORDER_SOURCE_ID
, ORDER_SOURCE
, CREATION_DATE
, TRANSACTIONAL_CURR_CODE
, SOLD_TO_ORG_ID
, SOLD_TO_CONTACT_ID
, SOLD_TO_CONTACT
, ACCOUNT_NUMBER
, ACCOUNT_NAME
, PARTY_ID
, SALESREP_NAME
, SALESREP_ID
, SALES_CHANNEL_CODE
, SALES_CHANNEL
, ORDER_TOTAL
, OPEN_FLAG
, UNFORM_ORDER_TOTAL
, QUOTE_NUMBER
, QUOTE_DATE
, ORDER_NUMBER_DISP
, ORDERED_DATE
FROM APPS.CSC_ORDER_HEADERS_V;
APPS.CSC_ORDER_HEADERS_V is not referenced by any database object
|
|
|