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

VIEW: APPS.IBE_ORDER_HEADER_ADV_V

Object Details
Object Name: IBE_ORDER_HEADER_ADV_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIBE.IBE_ORDER_HEADER_ADV_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_NUMBER NUMBER
Yes
CUST_PO_NUMBER VARCHAR2 (50)
ORDERED_DATE DATE

BOOKED_DATE DATE

ORDER_CATEGORY_CODE VARCHAR2 (30) Yes
ORDER_STATUS_CODE VARCHAR2 (30)
ORDER_STATUS VARCHAR2 (80) Yes
REFERENCE_NUMBER NUMBER

WEB_CONFIRM_NUMBER VARCHAR2 (50)
SOURCE_DOCUMENT_TYPE_ID NUMBER

CUST_ACCOUNT_ID NUMBER

PARTY_ID NUMBER (15) Yes
CUSTOMER_NAME VARCHAR2 (360) Yes
BILL_TO_ACCOUNT_ID NUMBER (15)
BILL_TO_ACCT_SITE_ID NUMBER (15)
SHIP_TO_ACCOUNT_ID NUMBER (15)
END_CUST_ACCOUNT_ID NUMBER

PRICING_AGREEMENT_ID NUMBER

CREATED_BY NUMBER
Yes
ORG_ID NUMBER

Query Text

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


SELECT HEADER_ID
,      ORDER_NUMBER
,      CUST_PO_NUMBER
,      ORDERED_DATE
,      BOOKED_DATE
,      ORDER_CATEGORY_CODE
,      ORDER_STATUS_CODE
,      ORDER_STATUS
,      REFERENCE_NUMBER
,      WEB_CONFIRM_NUMBER
,      SOURCE_DOCUMENT_TYPE_ID
,      CUST_ACCOUNT_ID
,      PARTY_ID
,      CUSTOMER_NAME
,      BILL_TO_ACCOUNT_ID
,      BILL_TO_ACCT_SITE_ID
,      SHIP_TO_ACCOUNT_ID
,      END_CUST_ACCOUNT_ID
,      PRICING_AGREEMENT_ID
,      CREATED_BY
,      ORG_ID
FROM APPS.IBE_ORDER_HEADER_ADV_V;

Dependencies

[top of page]

APPS.IBE_ORDER_HEADER_ADV_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
ViewOE_LOOKUPS
SynonymOE_ORDER_HEADERS_ALL

APPS.IBE_ORDER_HEADER_ADV_V is not referenced by any database object