eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	PO.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	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:

APPS: AP_TERMS; FINANCIALS_SYSTEM_PARAMS_ALL; FND_GLOBAL - show dependent code; 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_ARCHIVE_ALL; PO_LOOKUP_CODES; PO_RELEASES_ARCHIVE_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.PO_ECX_HEADER_V is not referenced by any database object