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


VIEW: APPS.PO_ECX_HEADER_V

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

CONTRACTB VARCHAR2 (20)
TYPE_LOOKUP_CODE VARCHAR2 (25)
RELEASE_ID NUMBER

RELEASE_NUM NUMBER

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)
PO_CURRENCY VARCHAR2 (15)
SUPP_ORG_NAME VARCHAR2 (240)
SUPP_OTF VARCHAR2 (1)
SUPP_PARTNER_TYPE CHAR (8)
SUPPLIER_PARTNER_ID NUMBER

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 (40)
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 VARCHAR2 (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

REVISION_NUM NUMBER

CONFIRMING_ORDER_FLAG VARCHAR2 (1)
Query Text

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


SELECT POID
,      CONTRACTB
,      TYPE_LOOKUP_CODE
,      RELEASE_ID
,      RELEASE_NUM
,      ACCEPTANCE_REQUIRED_FLAG
,      ACCEPTANCE_DUE_DATE
,      CREATION_DATE
,      SUPPLIER_ORDER_NUM
,      PO_CURRENCY
,      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
,      REVISION_NUM
,      CONFIRMING_ORDER_FLAG
FROM APPS.PO_ECX_HEADER_V;

Dependencies

[top of page]

APPS.PO_ECX_HEADER_V references the following:

SchemaAPPS
SynonymAP_TERMS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
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_ARCHIVE_ALL
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ARCHIVE_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.PO_ECX_HEADER_V is not referenced by any database object