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.ECE_POO_HEADERS_V

Object Details

Object Name:	ECE_POO_HEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EC.ECE_POO_HEADERS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view extracts header information
for the outbound Purchase Order (850/ORDERS) transaction.

[View Source]

Columns

Name	Datatype	Length	Comments
COMMUNICATION_METHOD	CHAR	(3)	Communication Method
TEST_FLAG	VARCHAR2	(1)	Test Indicator
DOCUMENT_ID	CHAR	(3)	Document ID
DOCUMENT_TYPE	VARCHAR2	(25)	Document Type
DOCUMENT_CODE	VARCHAR2	(20)	Document Code
TRANSLATOR_CODE	VARCHAR2	(30)	Trading Partner Translator Code
TP_LOCATION_CODE_EXT	VARCHAR2	(60)	Trading Partner Location Code
TP_DESCRIPTION	VARCHAR2	(240)	Trading Partner Description
TP_REFERENCE_EXT1	VARCHAR2	(240)	Trading Partner Reference 1 (Ext)
TP_REFERENCE_EXT2	VARCHAR2	(240)	Trading Partner Reference 2 (Ext)
TRANSACTION_DATE	DATE		Transaction Date/Time
TPH_ATTRIBUTE_CATEGORY	VARCHAR2	(150)	Trading Partner Attribute Category
TPH_ATTRIBUTE1	VARCHAR2	(150)	Trading Partner Attribute 1
TPH_ATTRIBUTE2	VARCHAR2	(150)	Trading Partner Attribute 2
TPH_ATTRIBUTE3	VARCHAR2	(150)	Trading Partner Attribute 3
TPH_ATTRIBUTE4	VARCHAR2	(150)	Trading Partner Attribute 4
TPH_ATTRIBUTE5	VARCHAR2	(150)	Trading Partner Attribute 5
TPH_ATTRIBUTE6	VARCHAR2	(150)	Trading Partner Attribute 6
TPH_ATTRIBUTE7	VARCHAR2	(150)	Trading Partner Attribute 7
TPH_ATTRIBUTE8	VARCHAR2	(150)	Trading Partner Attribute 8
TPH_ATTRIBUTE9	VARCHAR2	(150)	Trading Partner Attribute 9
TPH_ATTRIBUTE10	VARCHAR2	(150)	Trading Partner Attribute 10
TPH_ATTRIBUTE11	VARCHAR2	(150)	Trading Partner Attribute 11
TPH_ATTRIBUTE12	VARCHAR2	(150)	Trading Partner Attribute 12
TPH_ATTRIBUTE13	VARCHAR2	(150)	Trading Partner Attribute 13
TPH_ATTRIBUTE14	VARCHAR2	(150)	Trading Partner Attribute 14
TPH_ATTRIBUTE15	VARCHAR2	(150)	Trading Partner Attribute 15
TPD_ATTRIBUTE_CATEGORY	VARCHAR2	(150)	Trading Partner Detail Attribute Category
TPD_ATTRIBUTE1	VARCHAR2	(150)	Trading Partner Detail Attribute 1
TPD_ATTRIBUTE2	VARCHAR2	(150)	Trading Partner Detail Attribute 2
TPD_ATTRIBUTE3	VARCHAR2	(150)	Trading Partner Detail Attribute 3
TPD_ATTRIBUTE4	VARCHAR2	(150)	Trading Partner Detail Attribute 4
TPD_ATTRIBUTE5	VARCHAR2	(150)	Trading Partner Detail Attribute 5
PO_NUMBER	VARCHAR2	(20)	Purchase Order Number
POR_RELEASE_ID	NUMBER		Release ID
POR_RELEASE_NUM	NUMBER		Release Number
POR_RELEASE_DATE	DATE		Release Date
CREATION_DATE	DATE		Creation Date
REVISION_NUM	NUMBER		Revison Number
REVISED_DATE	DATE		Revision Date
COMMENTS	VARCHAR2	(240)	Description
PO_TYPE	VARCHAR2	(25)	Purchase Order Type
PAYMENT_TERMS	VARCHAR2	(50)	Payment Terms
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
CURRENCY_RATE	NUMBER		Currency Exchange Rate
SHIP_VIA	VARCHAR2	(25)	Ship Via
FOB_CODE	VARCHAR2	(25)	FOB Code
FREIGHT_TERMS	VARCHAR2	(25)	Freight Terms
CANCEL_FLAG	VARCHAR2	(1)	Cancelled Flag
ACCEPTANCE_REQUIRED_FLAG	VARCHAR2	(1)	Acceptance Required Flag
ACCEPTANCE_DUE_DATE	DATE		Acceptance Due By Date
CONFIRMING_ORDER_FLAG	VARCHAR2	(1)	Confirming Order Flag
BLANKET_START_DATE	DATE		Blanket Start Date
BLANKET_END_DATE	DATE		Blanket End Date
BLANKET_TOTAL_AMOUNT	NUMBER		Blanket Total Amount
SUPPLIER_NUMBER	VARCHAR2	(30)	Supplier Number
SUPPLIER_NAME	VARCHAR2	(240)	Supplier Name
NOTE_TO_VENDOR	VARCHAR2	(480)	Notes to Supplier
PO_ATTRIBUTE_CATEGORY	VARCHAR2	(30)	PO Attribute Category
PO_ATTRIBUTE1	VARCHAR2	(150)	PO Attribute 1
PO_ATTRIBUTE2	VARCHAR2	(150)	PO Attribute 2
PO_ATTRIBUTE3	VARCHAR2	(150)	PO Attribute 3
PO_ATTRIBUTE4	VARCHAR2	(150)	PO Attribute 4
PO_ATTRIBUTE5	VARCHAR2	(150)	PO Attribute 5
PO_ATTRIBUTE6	VARCHAR2	(150)	PO Attribute 6
PO_ATTRIBUTE7	VARCHAR2	(150)	PO Attribute 7
PO_ATTRIBUTE8	VARCHAR2	(150)	PO Attribute 8
PO_ATTRIBUTE9	VARCHAR2	(150)	PO Attribute 9
PO_ATTRIBUTE10	VARCHAR2	(150)	PO Attribute 10
PO_ATTRIBUTE11	VARCHAR2	(150)	PO Attribute 11
PO_ATTRIBUTE12	VARCHAR2	(150)	PO Attribute 12
PO_ATTRIBUTE13	VARCHAR2	(150)	PO Attribute 13
PO_ATTRIBUTE14	VARCHAR2	(150)	PO Attribute 14
PO_ATTRIBUTE15	VARCHAR2	(150)	PO Attribute 15
SU_ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Supplier Attribute Category
SU_ATTRIBUTE1	VARCHAR2	(150)	Supplier Attribute 1
SU_ATTRIBUTE2	VARCHAR2	(150)	Supplier Attribute 2
SU_ATTRIBUTE3	VARCHAR2	(150)	Supplier Attribute 3
SU_ATTRIBUTE4	VARCHAR2	(150)	Supplier Attribute 4
SU_ATTRIBUTE5	VARCHAR2	(150)	Supplier Attribute 5
SU_ATTRIBUTE6	VARCHAR2	(150)	Supplier Attribute 6
SU_ATTRIBUTE7	VARCHAR2	(150)	Supplier Attribute 7
SU_ATTRIBUTE8	VARCHAR2	(150)	Supplier Attribute 8
SU_ATTRIBUTE9	VARCHAR2	(150)	Supplier Attribute 9
SU_ATTRIBUTE10	VARCHAR2	(150)	Supplier Attribute 10
SU_ATTRIBUTE11	VARCHAR2	(150)	Supplier Attribute 11
SU_ATTRIBUTE12	VARCHAR2	(150)	Supplier Attribute 12
SU_ATTRIBUTE13	VARCHAR2	(150)	Supplier Attribute 13
SU_ATTRIBUTE14	VARCHAR2	(150)	Supplier Attribute 14
SU_ATTRIBUTE15	VARCHAR2	(150)	Supplier Attribute 15
SS_ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Supplier Site Attribute Category
SS_ATTRIBUTE1	VARCHAR2	(150)	Supplier Site Attribute 1
SS_ATTRIBUTE2	VARCHAR2	(150)	Supplier Site Attribute 2
SS_ATTRIBUTE3	VARCHAR2	(150)	Supplier Site Attribute 3
SS_ATTRIBUTE4	VARCHAR2	(150)	Supplier Site Attribute 4
SS_ATTRIBUTE5	VARCHAR2	(150)	Supplier Site Attribute 5
SS_ATTRIBUTE6	VARCHAR2	(150)	Supplier Site Attribute 6
SS_ATTRIBUTE7	VARCHAR2	(150)	Supplier Site Attribute 7
SS_ATTRIBUTE8	VARCHAR2	(150)	Supplier Site Attribute 8
SS_ATTRIBUTE9	VARCHAR2	(150)	Supplier Site Attribute 9
SS_ATTRIBUTE10	VARCHAR2	(150)	Supplier Site Attribute 10
SS_ATTRIBUTE11	VARCHAR2	(150)	Supplier Site Attribute 11
SS_ATTRIBUTE12	VARCHAR2	(150)	Supplier Site Attribute 12
SS_ATTRIBUTE13	VARCHAR2	(150)	Supplier Site Attribute 13
SS_ATTRIBUTE14	VARCHAR2	(150)	Supplier Site Attribute 14
SS_ATTRIBUTE15	VARCHAR2	(150)	Supplier Site Attribute 15
CUSTOMER_NUMBER	VARCHAR2	(25)	Supplier Customer Number
VENDOR_SITE_ID	NUMBER		Supplier Code
SU_ADDRESS_LINE1	VARCHAR2	(240)	Supplier Site Address Line 1
SU_ADDRESS_LINE2	VARCHAR2	(240)	Supplier Site Address Line 2
SU_ADDRESS_LINE3	VARCHAR2	(240)	Supplier Site Address Line 3
SU_ADDRESS_LINE4	VARCHAR2	(240)	Supplier Site Address Line 4
SU_CITY	VARCHAR2	(25)	Supplier Site City
SU_ZIP	VARCHAR2	(20)	Supplier Site Zip
SU_COUNTRY	VARCHAR2	(25)	Supplier Site Country
SU_STATE	VARCHAR2	(150)	Supplier Site State
SU_PROVINCE	VARCHAR2	(150)	Supplier Site Province
SU_AREA_CODE	VARCHAR2	(10)	Supplier Site Area Code
SU_PHONE	VARCHAR2	(15)	Supplier Site Phone
SU_FAX_AREA_CODE	VARCHAR2	(10)	Supplier Site Fax Area Code
SU_FAX	VARCHAR2	(15)	Supplier Site Fax
SU_TELEX	VARCHAR2	(15)	Supplier Site Telex
SUPPLIER_SITE_CODE	VARCHAR2	(15)	Supplier Site Code
CN_LAST_NAME	VARCHAR2	(15)	Supplier Contact Last Name
CN_FIRST_NAME	VARCHAR2	(15)	Supplier Contact First Name
CN_AREA_CODE	VARCHAR2	(10)	Supplier Contact Area Code
CN_PHONE	VARCHAR2	(40)	Supplier Contact Phone
ST_LOCATION_ID	NUMBER		Ship To Location ID
ST_LOCATION_CODE	VARCHAR2	(60)	Ship To Location Code
ST_EDI_LOCATION_CODE	VARCHAR2	(35)	Ship to location code
ST_CONTACT_LAST_NAME	VARCHAR2	(150)	Ship To Contact Last Name
ST_CONTACT_FIRST_NAME	VARCHAR2	(150)	Ship To Contact First Name
ST_NAME	VARCHAR2	(240)	Ship To Name
ST_ADDRESS_LINE1	VARCHAR2	(240)	Ship To Address Line 1
ST_ADDRESS_LINE2	VARCHAR2	(240)	Ship To Address Line 2
ST_ADDRESS_LINE3	VARCHAR2	(240)	Ship To Address Line 3
ST_CITY	VARCHAR2	(30)	Ship To City
ST_POSTAL_CODE	VARCHAR2	(30)	Ship To Postal Code
ST_COUNTRY	VARCHAR2	(60)	Ship To Country
ST_REGION1	VARCHAR2	(120)	Ship To Region 1
ST_REGION2	VARCHAR2	(120)	Ship To Region 2
ST_REGION3	VARCHAR2	(120)	Ship To Region 3
ST_PHONE1	VARCHAR2	(60)	Ship To Phone 1
ST_PHONE2	VARCHAR2	(60)	Ship To Phone 2
ST_PHONE3	VARCHAR2	(60)	Ship To Phone 3
BT_LOCATION_ID	NUMBER		Bill To Location ID
BT_LOCATION_CODE	VARCHAR2	(60)	Bill To Location Code
BT_EDI_LOCATION_CODE	VARCHAR2	(35)	Bill to Location Code
BT_CONTACT_LAST_NAME	VARCHAR2	(150)	Bill To Contact Last Name
BT_CONTACT_FIRST_NAME	VARCHAR2	(150)	Bill To Contact First Name
BT_NAME	VARCHAR2	(240)	Bill To Name
BT_ADDRESS_LINE1	VARCHAR2	(240)	Bill To Address Line 1
BT_ADDRESS_LINE2	VARCHAR2	(240)	Bill To Address Line 2
BT_ADDRESS_LINE3	VARCHAR2	(240)	Bill To Address Line 3
BT_CITY	VARCHAR2	(30)	Bill To City
BT_POSTAL_CODE	VARCHAR2	(30)	Bill To Postal Code
BT_COUNTRY	VARCHAR2	(60)	Bill To Country
BT_REGION1	VARCHAR2	(120)	Bill To Region 1
BT_REGION2	VARCHAR2	(120)	Bill To Region 2
BT_REGION3	VARCHAR2	(120)	Bill To Region 3
BT_PHONE1	VARCHAR2	(60)	Bill To Phone 1
BT_PHONE2	VARCHAR2	(60)	Bill To Phone 2
BT_PHONE3	VARCHAR2	(60)	Bill To Phone 3
BUYER_LAST_NAME	VARCHAR2	(150)	Buyer Last Name
BUYER_FIRST_NAME	VARCHAR2	(150)	Buyer First Name
BUYER_EMAIL_ADDRESS	VARCHAR2	(240)	Buyer E-Mail Address
BUYER_WORK_TELEPHONE	VARCHAR2	(60)	Buyer Work Phone
BUYER_MISC_TELEPHONE1	VARCHAR2	(60)	Buyer Misc Phone 1
BUYER_MISC_TELEPHONE2	VARCHAR2	(60)	Buyer Misc Phone 2
BUYER_MISC_TELEPHONE3	VARCHAR2	(60)	Buyer Misc Phone 3
PO_HEADER_ID	NUMBER		Purchase Order Header ID
DOCUMENT_STANDARD	VARCHAR2	(30)	Document Standard
PCARDMEMBER_NAME	VARCHAR2	(240)	Procurement Card Member Name
PCARD_NUMBER	VARCHAR2	(30)	Procurement Card Number
PCARD_EXPIRATION_DATE	DATE		Procurement Card Expiration Date
PCARD_BRAND	VARCHAR2	(25)	Procurement Card Brand
MAP_ID	NUMBER	(15)	Mapping Repository ID
ORG_ID	NUMBER		Org Id
SHIPPING_CONTROL	VARCHAR2	(30)	SHIPPING_CONTROL

Query Text

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


SELECT COMMUNICATION_METHOD
,      TEST_FLAG
,      DOCUMENT_ID
,      DOCUMENT_TYPE
,      DOCUMENT_CODE
,      TRANSLATOR_CODE
,      TP_LOCATION_CODE_EXT
,      TP_DESCRIPTION
,      TP_REFERENCE_EXT1
,      TP_REFERENCE_EXT2
,      TRANSACTION_DATE
,      TPH_ATTRIBUTE_CATEGORY
,      TPH_ATTRIBUTE1
,      TPH_ATTRIBUTE2
,      TPH_ATTRIBUTE3
,      TPH_ATTRIBUTE4
,      TPH_ATTRIBUTE5
,      TPH_ATTRIBUTE6
,      TPH_ATTRIBUTE7
,      TPH_ATTRIBUTE8
,      TPH_ATTRIBUTE9
,      TPH_ATTRIBUTE10
,      TPH_ATTRIBUTE11
,      TPH_ATTRIBUTE12
,      TPH_ATTRIBUTE13
,      TPH_ATTRIBUTE14
,      TPH_ATTRIBUTE15
,      TPD_ATTRIBUTE_CATEGORY
,      TPD_ATTRIBUTE1
,      TPD_ATTRIBUTE2
,      TPD_ATTRIBUTE3
,      TPD_ATTRIBUTE4
,      TPD_ATTRIBUTE5
,      PO_NUMBER
,      POR_RELEASE_ID
,      POR_RELEASE_NUM
,      POR_RELEASE_DATE
,      CREATION_DATE
,      REVISION_NUM
,      REVISED_DATE
,      COMMENTS
,      PO_TYPE
,      PAYMENT_TERMS
,      CURRENCY_CODE
,      CURRENCY_RATE
,      SHIP_VIA
,      FOB_CODE
,      FREIGHT_TERMS
,      CANCEL_FLAG
,      ACCEPTANCE_REQUIRED_FLAG
,      ACCEPTANCE_DUE_DATE
,      CONFIRMING_ORDER_FLAG
,      BLANKET_START_DATE
,      BLANKET_END_DATE
,      BLANKET_TOTAL_AMOUNT
,      SUPPLIER_NUMBER
,      SUPPLIER_NAME
,      NOTE_TO_VENDOR
,      PO_ATTRIBUTE_CATEGORY
,      PO_ATTRIBUTE1
,      PO_ATTRIBUTE2
,      PO_ATTRIBUTE3
,      PO_ATTRIBUTE4
,      PO_ATTRIBUTE5
,      PO_ATTRIBUTE6
,      PO_ATTRIBUTE7
,      PO_ATTRIBUTE8
,      PO_ATTRIBUTE9
,      PO_ATTRIBUTE10
,      PO_ATTRIBUTE11
,      PO_ATTRIBUTE12
,      PO_ATTRIBUTE13
,      PO_ATTRIBUTE14
,      PO_ATTRIBUTE15
,      SU_ATTRIBUTE_CATEGORY
,      SU_ATTRIBUTE1
,      SU_ATTRIBUTE2
,      SU_ATTRIBUTE3
,      SU_ATTRIBUTE4
,      SU_ATTRIBUTE5
,      SU_ATTRIBUTE6
,      SU_ATTRIBUTE7
,      SU_ATTRIBUTE8
,      SU_ATTRIBUTE9
,      SU_ATTRIBUTE10
,      SU_ATTRIBUTE11
,      SU_ATTRIBUTE12
,      SU_ATTRIBUTE13
,      SU_ATTRIBUTE14
,      SU_ATTRIBUTE15
,      SS_ATTRIBUTE_CATEGORY
,      SS_ATTRIBUTE1
,      SS_ATTRIBUTE2
,      SS_ATTRIBUTE3
,      SS_ATTRIBUTE4
,      SS_ATTRIBUTE5
,      SS_ATTRIBUTE6
,      SS_ATTRIBUTE7
,      SS_ATTRIBUTE8
,      SS_ATTRIBUTE9
,      SS_ATTRIBUTE10
,      SS_ATTRIBUTE11
,      SS_ATTRIBUTE12
,      SS_ATTRIBUTE13
,      SS_ATTRIBUTE14
,      SS_ATTRIBUTE15
,      CUSTOMER_NUMBER
,      VENDOR_SITE_ID
,      SU_ADDRESS_LINE1
,      SU_ADDRESS_LINE2
,      SU_ADDRESS_LINE3
,      SU_ADDRESS_LINE4
,      SU_CITY
,      SU_ZIP
,      SU_COUNTRY
,      SU_STATE
,      SU_PROVINCE
,      SU_AREA_CODE
,      SU_PHONE
,      SU_FAX_AREA_CODE
,      SU_FAX
,      SU_TELEX
,      SUPPLIER_SITE_CODE
,      CN_LAST_NAME
,      CN_FIRST_NAME
,      CN_AREA_CODE
,      CN_PHONE
,      ST_LOCATION_ID
,      ST_LOCATION_CODE
,      ST_EDI_LOCATION_CODE
,      ST_CONTACT_LAST_NAME
,      ST_CONTACT_FIRST_NAME
,      ST_NAME
,      ST_ADDRESS_LINE1
,      ST_ADDRESS_LINE2
,      ST_ADDRESS_LINE3
,      ST_CITY
,      ST_POSTAL_CODE
,      ST_COUNTRY
,      ST_REGION1
,      ST_REGION2
,      ST_REGION3
,      ST_PHONE1
,      ST_PHONE2
,      ST_PHONE3
,      BT_LOCATION_ID
,      BT_LOCATION_CODE
,      BT_EDI_LOCATION_CODE
,      BT_CONTACT_LAST_NAME
,      BT_CONTACT_FIRST_NAME
,      BT_NAME
,      BT_ADDRESS_LINE1
,      BT_ADDRESS_LINE2
,      BT_ADDRESS_LINE3
,      BT_CITY
,      BT_POSTAL_CODE
,      BT_COUNTRY
,      BT_REGION1
,      BT_REGION2
,      BT_REGION3
,      BT_PHONE1
,      BT_PHONE2
,      BT_PHONE3
,      BUYER_LAST_NAME
,      BUYER_FIRST_NAME
,      BUYER_EMAIL_ADDRESS
,      BUYER_WORK_TELEPHONE
,      BUYER_MISC_TELEPHONE1
,      BUYER_MISC_TELEPHONE2
,      BUYER_MISC_TELEPHONE3
,      PO_HEADER_ID
,      DOCUMENT_STANDARD
,      PCARDMEMBER_NAME
,      PCARD_NUMBER
,      PCARD_EXPIRATION_DATE
,      PCARD_BRAND
,      MAP_ID
,      ORG_ID
,      SHIPPING_CONTROL
FROM APPS.ECE_POO_HEADERS_V;

Dependencies

[top of page]

APPS.ECE_POO_HEADERS_V references the following:

APPS: AP_CARDS; AP_CARD_PROFILES; AP_CARD_PROGRAMS; AP_CARD_SUPPLIERS; AP_TERMS; ECE_TP_DETAILS; ECE_TP_HEADERS; FINANCIALS_SYSTEM_PARAMETERS; FND_CURRENCIES_VL; HR_GENERAL - show dependent code; HR_LOCATIONS; HR_LOCATIONS_ALL; HR_LOCATIONS_ALL_TL; IBY_CREDITCARD; PER_ADDRESSES; PER_ALL_PEOPLE_F; PER_PHONES; PO_HEADERS; PO_HEADERS_ARCHIVE; PO_RELEASES; PO_RELEASES_ARCHIVE; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES

APPS.ECE_POO_HEADERS_V is not referenced by any database object