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


VIEW: APPS.PO_CXML_HEADER_ARCH_V

Object Details
Object Name: PO_CXML_HEADER_ARCH_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_CXML_HEADER_ARCH_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

Document header unique identifier
ORDERID VARCHAR2 (20)
Document number
REVISION_NUM NUMBER

Document revision number
RELEASE_ID NUMBER

RELEASE_NUM NUMBER

ORDER_TYPE CHAR (7)
PO_CURRENCY VARCHAR2 (15)
ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
ACCEPTANCE_DUE_DATE DATE

CREATION_DATE DATE

Standard who column - date when this row was created.
SUPPLIER_ORDER_NUM VARCHAR2 (25)
SUPP_ORG_NAME VARCHAR2 (240)
SUPPLIER_PARTNER_ID VARCHAR2 (30)
SUPPLIER_PARTNER_ID_X VARCHAR2 (60)
ORDER_TOTAL NUMBER

SUPP_CURRENCY VARCHAR2 (15)
VAT_REGISTRATION_NUM VARCHAR2 (20)
SUPP_ADDR_LINE123 VARCHAR2 (720)
SUPP_ADDR_LINE1 VARCHAR2 (240)
SUPP_ADDR_LINE2 VARCHAR2 (240)
SUPP_ADDR_LINE3 VARCHAR2 (240)
SUPP_CITY VARCHAR2 (25)
SUPP_COUNTRY VARCHAR2 (25)
SUPP_ZIP VARCHAR2 (20)
SUPP_STATE VARCHAR2 (150)
SUPP_PHONE VARCHAR2 (26)
BUYING_ORG_NAME VARCHAR2 (240)
PARTNER_ID NUMBER

PARTNER_ID_X VARCHAR2 (35)
BUYING_ORG_CURRENCY VARCHAR2 (15)
BUYING_ORG_ADDR_LINE123 VARCHAR2 (720)
BUYING_ORG_ADDR_LINE1 VARCHAR2 (240)
BUYING_ORG_ADDR_LINE2 VARCHAR2 (240)
BUYING_ORG_ADDR_LINE3 VARCHAR2 (240)
BUYING_ORG_CITY VARCHAR2 (30)
BUYING_ORG_COUNTRY VARCHAR2 (60)
BUYING_ORG_ZIP VARCHAR2 (30)
BUYING_ORG_STATE VARCHAR2 (120)
BUYING_ORG_PHONE1 VARCHAR2 (60)
BUYING_ORG_PHONE2 VARCHAR2 (60)
BUYING_ORG_PHONE3 VARCHAR2 (60)
BUYER_ID NUMBER (9)
BUYER_FULL_NAME VARCHAR2 (240)
BUYER_EMAIL VARCHAR2 (240)
BUYER_TELEPHONE VARCHAR2 (4000)
BILLTO_ORG_NAME VARCHAR2 (240)
BILLTO_ORG_CURRENCY VARCHAR2 (15)
BILLTO_ORG_ADDR_LINE123 VARCHAR2 (720)
BILLTO_ORG_ADDR_LINE1 VARCHAR2 (240)
BILLTO_ORG_ADDR_LINE2 VARCHAR2 (240)
BILLTO_ORG_ADDR_LINE3 VARCHAR2 (240)
BILLTO_ORG_CITY VARCHAR2 (30)
BILLTO_ORG_COUNTRY VARCHAR2 (60)
BILLTO_ORG_ZIP VARCHAR2 (30)
BILLTO_ORG_STATE VARCHAR2 (120)
BILLTO_ORG_PHONE1 VARCHAR2 (60)
BILLTO_ORG_PHONE2 VARCHAR2 (60)
BILLTO_ORG_PHONE3 VARCHAR2 (60)
CARRIER_ORG_NAME VARCHAR2 (25)
PAYMENT_TERMS_ID NUMBER (15)
PAYMENT_TERMS_NAME VARCHAR2 (50)
PAYMENT_TERMS_DESCRIPTION VARCHAR2 (240)
FOB_CODE VARCHAR2 (30)
FOB_NAME VARCHAR2 (80)
FOB_DESC VARCHAR2 (240)
FREIGHT_CODE VARCHAR2 (30)
FREIGHT_NAME VARCHAR2 (80)
FREIGHT_DESC VARCHAR2 (240)
NOTE_TO_AUTHORIZER VARCHAR2 (240)
NOTE_TO_VENDOR VARCHAR2 (480)
NOTE_TO_RECEIVER VARCHAR2 (480)
COMMENTS VARCHAR2 (240)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

CONFIRMING_ORDER_FLAG VARCHAR2 (1)
EXCHANGE_RATE NUMBER

EXCH_RATE_DATE DATE

CARD_NAME VARCHAR2 (80)
CARD_NUM VARCHAR2 (80)
CARD_EXP_DATE DATE

CUSTOMER_NUM VARCHAR2 (25)
SUPPLIER_FAX VARCHAR2 (25)
SUPPLIER_EMAIL VARCHAR2 (2000)
SUP_CONTACT_NAME VARCHAR2 (47)
SUP_CONTACT_PHONE VARCHAR2 (51)
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
PCARD_ID NUMBER (15)
SUP_SITE_CODE VARCHAR2 (15)
NUM_1099 VARCHAR2 (20)
ACKREQD CHAR (7)
ACKBYDATE CHAR (9)
SUPPNOTE CHAR (8)
SHIP_TO_LOCATION_ID NUMBER

BILL_TO_LOCATION_ID NUMBER

TYPE_LOOKUP_CODE VARCHAR2 (25)
Query Text

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


SELECT HEADER_ID
,      ORDERID
,      REVISION_NUM
,      RELEASE_ID
,      RELEASE_NUM
,      ORDER_TYPE
,      PO_CURRENCY
,      ACCEPTANCE_REQUIRED_FLAG
,      ACCEPTANCE_DUE_DATE
,      CREATION_DATE
,      SUPPLIER_ORDER_NUM
,      SUPP_ORG_NAME
,      SUPPLIER_PARTNER_ID
,      SUPPLIER_PARTNER_ID_X
,      ORDER_TOTAL
,      SUPP_CURRENCY
,      VAT_REGISTRATION_NUM
,      SUPP_ADDR_LINE123
,      SUPP_ADDR_LINE1
,      SUPP_ADDR_LINE2
,      SUPP_ADDR_LINE3
,      SUPP_CITY
,      SUPP_COUNTRY
,      SUPP_ZIP
,      SUPP_STATE
,      SUPP_PHONE
,      BUYING_ORG_NAME
,      PARTNER_ID
,      PARTNER_ID_X
,      BUYING_ORG_CURRENCY
,      BUYING_ORG_ADDR_LINE123
,      BUYING_ORG_ADDR_LINE1
,      BUYING_ORG_ADDR_LINE2
,      BUYING_ORG_ADDR_LINE3
,      BUYING_ORG_CITY
,      BUYING_ORG_COUNTRY
,      BUYING_ORG_ZIP
,      BUYING_ORG_STATE
,      BUYING_ORG_PHONE1
,      BUYING_ORG_PHONE2
,      BUYING_ORG_PHONE3
,      BUYER_ID
,      BUYER_FULL_NAME
,      BUYER_EMAIL
,      BUYER_TELEPHONE
,      BILLTO_ORG_NAME
,      BILLTO_ORG_CURRENCY
,      BILLTO_ORG_ADDR_LINE123
,      BILLTO_ORG_ADDR_LINE1
,      BILLTO_ORG_ADDR_LINE2
,      BILLTO_ORG_ADDR_LINE3
,      BILLTO_ORG_CITY
,      BILLTO_ORG_COUNTRY
,      BILLTO_ORG_ZIP
,      BILLTO_ORG_STATE
,      BILLTO_ORG_PHONE1
,      BILLTO_ORG_PHONE2
,      BILLTO_ORG_PHONE3
,      CARRIER_ORG_NAME
,      PAYMENT_TERMS_ID
,      PAYMENT_TERMS_NAME
,      PAYMENT_TERMS_DESCRIPTION
,      FOB_CODE
,      FOB_NAME
,      FOB_DESC
,      FREIGHT_CODE
,      FREIGHT_NAME
,      FREIGHT_DESC
,      NOTE_TO_AUTHORIZER
,      NOTE_TO_VENDOR
,      NOTE_TO_RECEIVER
,      COMMENTS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CONFIRMING_ORDER_FLAG
,      EXCHANGE_RATE
,      EXCH_RATE_DATE
,      CARD_NAME
,      CARD_NUM
,      CARD_EXP_DATE
,      CUSTOMER_NUM
,      SUPPLIER_FAX
,      SUPPLIER_EMAIL
,      SUP_CONTACT_NAME
,      SUP_CONTACT_PHONE
,      LAST_UPDATE_DATE
,      PCARD_ID
,      SUP_SITE_CODE
,      NUM_1099
,      ACKREQD
,      ACKBYDATE
,      SUPPNOTE
,      SHIP_TO_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      TYPE_LOOKUP_CODE
FROM APPS.PO_CXML_HEADER_ARCH_V;

Dependencies

[top of page]

APPS.PO_CXML_HEADER_ARCH_V references the following:

SchemaAPPS
SynonymAP_CARDS_ALL
SynonymAP_TERMS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewGL_SETS_OF_BOOKS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
ViewHR_ORGANIZATION_UNITS_V
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ALL_PEOPLE_F
PL/SQL PackagePOGOT_S - show dependent code
SynonymPO_HEADERS_ALL
SynonymPO_HEADERS_ARCHIVE_ALL
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ARCHIVE_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.PO_CXML_HEADER_ARCH_V is not referenced by any database object