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


VIEW: APPS.PO_ECX_HEADER_ARCH_V

Object Details
Object Name: PO_ECX_HEADER_ARCH_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_ECX_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
POID NUMBER

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

Document revision number
RELEASE_ID NUMBER

RELEASE_NUM NUMBER

TYPE_LOOKUP_CODE VARCHAR2 (25)
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)
SUPP_OTF VARCHAR2 (1)
SUPP_PARTNER_TYPE CHAR (8)
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_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)
BUYING_ORG_OTF CHAR (1)
BUYING_ORG_PARTNER_TYPE CHAR (6)
PARTNER_ID NUMBER

PARTNER_ID_X VARCHAR2 (35)
BUYING_ORG_CURRENCY VARCHAR2 (15)
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_OTF CHAR (1)
BILLTO_PARTNER_TYPE CHAR (6)
BILLTO_ORG_CURRENCY VARCHAR2 (15)
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)
CARRIER_ORG_OTF VARCHAR2 (1)
CARRIER_PARTNER_TYPE CHAR (7)
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

DFF_HDR_ATTR1 VARCHAR2 (150)
DFF_HDR_ATTR2 VARCHAR2 (150)
DFF_HDR_ATTR3 VARCHAR2 (150)
DFF_HDR_ATTR4 VARCHAR2 (150)
DFF_HDR_ATTR5 VARCHAR2 (150)
DFF_HDR_ATTR6 VARCHAR2 (150)
DFF_HDR_ATTR7 VARCHAR2 (150)
DFF_HDR_ATTR8 VARCHAR2 (150)
DFF_HDR_ATTR9 VARCHAR2 (150)
DFF_HDR_ATTR10 VARCHAR2 (150)
DFF_HDR_ATTR11 VARCHAR2 (150)
DFF_HDR_ATTR12 VARCHAR2 (150)
DFF_HDR_ATTR13 VARCHAR2 (150)
DFF_HDR_ATTR14 VARCHAR2 (150)
DFF_HDR_ATTR15 VARCHAR2 (150)
DFF_HDR_ATTR16 VARCHAR2 (30)
CARD_NAME VARCHAR2 (80)
CARD_NUM VARCHAR2 (80)
CARD_EXP_DATE DATE

DFF_VEND_ATTR1 VARCHAR2 (150)
DFF_VEND_ATTR2 VARCHAR2 (150)
DFF_VEND_ATTR3 VARCHAR2 (150)
DFF_VEND_ATTR4 VARCHAR2 (150)
DFF_VEND_ATTR5 VARCHAR2 (150)
DFF_VEND_ATTR6 VARCHAR2 (150)
DFF_VEND_ATTR7 VARCHAR2 (150)
DFF_VEND_ATTR8 VARCHAR2 (150)
DFF_VEND_ATTR9 VARCHAR2 (150)
DFF_VEND_ATTR10 VARCHAR2 (150)
DFF_VEND_ATTR11 VARCHAR2 (150)
DFF_VEND_ATTR12 VARCHAR2 (150)
DFF_VEND_ATTR13 VARCHAR2 (150)
DFF_VEND_ATTR14 VARCHAR2 (150)
DFF_VEND_ATTR15 VARCHAR2 (150)
DFF_VEND_ATTR16 VARCHAR2 (30)
DFF_VEND_SITE_ATTR1 VARCHAR2 (150)
DFF_VEND_SITE_ATTR2 VARCHAR2 (150)
DFF_VEND_SITE_ATTR3 VARCHAR2 (150)
DFF_VEND_SITE_ATTR4 VARCHAR2 (150)
DFF_VEND_SITE_ATTR5 VARCHAR2 (150)
DFF_VEND_SITE_ATTR6 VARCHAR2 (150)
DFF_VEND_SITE_ATTR7 VARCHAR2 (150)
DFF_VEND_SITE_ATTR8 VARCHAR2 (150)
DFF_VEND_SITE_ATTR9 VARCHAR2 (150)
DFF_VEND_SITE_ATTR10 VARCHAR2 (150)
DFF_VEND_SITE_ATTR11 VARCHAR2 (150)
DFF_VEND_SITE_ATTR12 VARCHAR2 (150)
DFF_VEND_SITE_ATTR13 VARCHAR2 (150)
DFF_VEND_SITE_ATTR14 VARCHAR2 (150)
DFF_VEND_SITE_ATTR15 VARCHAR2 (150)
DFF_VEND_SITE_ATTR16 VARCHAR2 (30)
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)
PO_REVISION_NUM NUMBER

LATEST_EXTERNAL_FLAG VARCHAR2 (1)
SHIPPING_CONTROL VARCHAR2 (30)
POSTATUS VARCHAR2 (9)
Query Text

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


SELECT POID
,      CONTRACTB
,      REVISION_NUM
,      RELEASE_ID
,      RELEASE_NUM
,      TYPE_LOOKUP_CODE
,      PO_CURRENCY
,      ACCEPTANCE_REQUIRED_FLAG
,      ACCEPTANCE_DUE_DATE
,      CREATION_DATE
,      SUPPLIER_ORDER_NUM
,      SUPP_ORG_NAME
,      SUPP_OTF
,      SUPP_PARTNER_TYPE
,      SUPPLIER_PARTNER_ID
,      SUPPLIER_PARTNER_ID_X
,      ORDER_TOTAL
,      SUPP_CURRENCY
,      VAT_REGISTRATION_NUM
,      SUPP_ADDR_LINE1
,      SUPP_ADDR_LINE2
,      SUPP_ADDR_LINE3
,      SUPP_CITY
,      SUPP_COUNTRY
,      SUPP_ZIP
,      SUPP_STATE
,      SUPP_PHONE
,      BUYING_ORG_NAME
,      BUYING_ORG_OTF
,      BUYING_ORG_PARTNER_TYPE
,      PARTNER_ID
,      PARTNER_ID_X
,      BUYING_ORG_CURRENCY
,      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_OTF
,      BILLTO_PARTNER_TYPE
,      BILLTO_ORG_CURRENCY
,      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
,      CARRIER_ORG_OTF
,      CARRIER_PARTNER_TYPE
,      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
,      DFF_HDR_ATTR1
,      DFF_HDR_ATTR2
,      DFF_HDR_ATTR3
,      DFF_HDR_ATTR4
,      DFF_HDR_ATTR5
,      DFF_HDR_ATTR6
,      DFF_HDR_ATTR7
,      DFF_HDR_ATTR8
,      DFF_HDR_ATTR9
,      DFF_HDR_ATTR10
,      DFF_HDR_ATTR11
,      DFF_HDR_ATTR12
,      DFF_HDR_ATTR13
,      DFF_HDR_ATTR14
,      DFF_HDR_ATTR15
,      DFF_HDR_ATTR16
,      CARD_NAME
,      CARD_NUM
,      CARD_EXP_DATE
,      DFF_VEND_ATTR1
,      DFF_VEND_ATTR2
,      DFF_VEND_ATTR3
,      DFF_VEND_ATTR4
,      DFF_VEND_ATTR5
,      DFF_VEND_ATTR6
,      DFF_VEND_ATTR7
,      DFF_VEND_ATTR8
,      DFF_VEND_ATTR9
,      DFF_VEND_ATTR10
,      DFF_VEND_ATTR11
,      DFF_VEND_ATTR12
,      DFF_VEND_ATTR13
,      DFF_VEND_ATTR14
,      DFF_VEND_ATTR15
,      DFF_VEND_ATTR16
,      DFF_VEND_SITE_ATTR1
,      DFF_VEND_SITE_ATTR2
,      DFF_VEND_SITE_ATTR3
,      DFF_VEND_SITE_ATTR4
,      DFF_VEND_SITE_ATTR5
,      DFF_VEND_SITE_ATTR6
,      DFF_VEND_SITE_ATTR7
,      DFF_VEND_SITE_ATTR8
,      DFF_VEND_SITE_ATTR9
,      DFF_VEND_SITE_ATTR10
,      DFF_VEND_SITE_ATTR11
,      DFF_VEND_SITE_ATTR12
,      DFF_VEND_SITE_ATTR13
,      DFF_VEND_SITE_ATTR14
,      DFF_VEND_SITE_ATTR15
,      DFF_VEND_SITE_ATTR16
,      CUSTOMER_NUM
,      SUPPLIER_FAX
,      SUPPLIER_EMAIL
,      SUP_CONTACT_NAME
,      SUP_CONTACT_PHONE
,      LAST_UPDATE_DATE
,      PCARD_ID
,      SUP_SITE_CODE
,      NUM_1099
,      PO_REVISION_NUM
,      LATEST_EXTERNAL_FLAG
,      SHIPPING_CONTROL
,      POSTATUS
FROM APPS.PO_ECX_HEADER_ARCH_V;

Dependencies

[top of page]

APPS.PO_ECX_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_ECX_HEADER_ARCH_V is not referenced by any database object