[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_ECX_HEADER_ARCH_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PO.PO_ECX_HEADER_ARCH_V
|
| 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 |
|---|---|---|---|---|
| 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) |
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;
APPS
AP_CARDS_ALL
AP_TERMS
FINANCIALS_SYSTEM_PARAMS_ALL
FND_GLOBAL
- show dependent code
GL_SETS_OF_BOOKS
HR_ALL_ORGANIZATION_UNITS_TL
HR_API
- show dependent code
HR_GENERAL
- show dependent code
HR_LOCATIONS_ALL
HR_ORGANIZATION_UNITS_V
HR_SECURITY
- show dependent code
PER_ALL_PEOPLE_F
POGOT_S
- show dependent code
PO_HEADERS_ALL
PO_HEADERS_ARCHIVE_ALL
PO_LOOKUP_CODES
PO_RELEASES_ARCHIVE_ALL
PO_VENDORS
PO_VENDOR_CONTACTS
PO_VENDOR_SITES_ALL
APPS.PO_ECX_HEADER_ARCH_V is not referenced by any database object
|
|
|
|