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]

TABLE: PO.PO_HEADERS_INTERFACE

Object Details

Object Name:	PO_HEADERS_INTERFACE
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_HEADERS_INTERFACE
Subobject Name:
Status:	VALID

PO_HEADERS_INTERFACE is the interface table that holds header
information for the PDOI program to create standard/blanket purchase
orders and catalog quotations.
The PDOI program validates your data, derives or defaults additional
information and writes an error message for every validation that
fails into the PO_INTERFACE_ERRORS table.
Scope: public
Product: PO
Display Name: PO Headers Interface
Category: BUSINESS_ENTITY PO_BLANKET_PURCHASE_AGREEMENT
Category: BUSINESS_ENTITY PO_CONTRACT_PURCHASE_AGREEMENT
Category: BUSINESS_ENTITY PO_GLOBAL_BLANKET_AGREEMENT
Category: BUSINESS_ENTITY PO_GLOBAL_CONTRACT_AGREEMENT
Category: BUSINESS_ENTITY PO_PRICE_BREAKS
Category: BUSINESS_ENTITY PO_STANDARD_PURCHASE_ORDER

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_HEADERS_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	INTERFACE_HEADER_ID
PO_HEADERS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PROCESSING_ID PROCESSING_ROUND_NUM
PO_HEADERS_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID
PO_HEADERS_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	VENDOR_DOC_NUM
PO_HEADERS_INTERFACE_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PO_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_HEADER_ID	NUMBER		Yes	Interface header unique identifier
BATCH_ID	NUMBER			Batch unique identifier
INTERFACE_SOURCE_CODE	VARCHAR2	(25)		Interface source
PROCESS_CODE	VARCHAR2	(25)		Interface record status
ACTION	VARCHAR2	(25)		Interface action: ADD, NEW
GROUP_CODE	VARCHAR2	(25)		Requisition line grouping
ORG_ID	NUMBER			Organization identifier
DOCUMENT_TYPE_CODE	VARCHAR2	(25)		Document type to be created: PO or RFQ
DOCUMENT_SUBTYPE	VARCHAR2	(25)		Document subtype
DOCUMENT_NUM	VARCHAR2	(20)		Document number
PO_HEADER_ID	NUMBER			Document header unique identifier
RELEASE_NUM	NUMBER			Release number
PO_RELEASE_ID	NUMBER			Release unique identifier
RELEASE_DATE	DATE			Release date
CURRENCY_CODE	VARCHAR2	(15)		Currency code
RATE_TYPE	VARCHAR2	(30)		Rate type
RATE_TYPE_CODE	VARCHAR2	(30)		Rate type code
RATE_DATE	DATE			Rate date
RATE	NUMBER			Rate
AGENT_NAME	VARCHAR2	(240)		Buyer name
AGENT_ID	NUMBER			Buyer unique identifier
VENDOR_NAME	VARCHAR2	(240)		Supplier name
VENDOR_ID	NUMBER			Supplier unique identifier
VENDOR_SITE_CODE	VARCHAR2	(15)		Supplier site code
VENDOR_SITE_ID	NUMBER			Supplier site unique identifier
VENDOR_CONTACT	VARCHAR2	(240)		Supplier contact name
VENDOR_CONTACT_ID	NUMBER			Supplier contact unique identifier
SHIP_TO_LOCATION	VARCHAR2	(60)		Ship-to location code
SHIP_TO_LOCATION_ID	NUMBER			Ship-to location unique identifier
BILL_TO_LOCATION	VARCHAR2	(60)		Bill-to location code
BILL_TO_LOCATION_ID	NUMBER			Bill-to location unique identifier
PAYMENT_TERMS	VARCHAR2	(50)		Payment terms name
TERMS_ID	NUMBER			Payment terms unique identifier
FREIGHT_CARRIER	VARCHAR2	(25)		Freight carrier
FOB	VARCHAR2	(25)		Type of free-on-board terms for the document
FREIGHT_TERMS	VARCHAR2	(25)		Freight terms
APPROVAL_STATUS	VARCHAR2	(25)		Approval status
APPROVED_DATE	DATE			Approval date
REVISED_DATE	DATE			Revised date
REVISION_NUM	NUMBER			Document revision number
NOTE_TO_VENDOR	VARCHAR2	(480)		Note to supplier
NOTE_TO_RECEIVER	VARCHAR2	(480)		Note to receiver
CONFIRMING_ORDER_FLAG	VARCHAR2	(1)		Indicates whether purchase order is a confirming order
COMMENTS	VARCHAR2	(240)		Comments
ACCEPTANCE_REQUIRED_FLAG	VARCHAR2	(1)		Indicates whether acceptance from the supplier is required or not
ACCEPTANCE_DUE_DATE	DATE			Date by which the supplier should accept the purchase order
AMOUNT_AGREED	NUMBER			Amount agreed for the planned or blanket purchase order
AMOUNT_LIMIT	NUMBER			Maximum amount that can be released against the purchase order (blanket, contract, or planned)
MIN_RELEASE_AMOUNT	NUMBER			Minimum amount that can be released against a blanket or planned purchase order
EFFECTIVE_DATE	DATE			Date document becomes effective
EXPIRATION_DATE	DATE			Date document expires
PRINT_COUNT	NUMBER			Print count
PRINTED_DATE	DATE			Date last printed
FIRM_FLAG	VARCHAR2	(25)		Indicates whether you want to prevent this purchase order from being automatically rescheduled by your manufacturing application
FROZEN_FLAG	VARCHAR2	(1)		Indicator of whether the document is frozen
CLOSED_CODE	VARCHAR2	(25)		Closed status
CLOSED_DATE	DATE			Closed date
REPLY_DATE	DATE			Date the supplier replied to the RFQ
REPLY_METHOD	VARCHAR2	(25)		Method the supplier should use to reply to the RFQ
RFQ_CLOSE_DATE	DATE			Date RFQ will be closed
QUOTE_WARNING_DELAY	NUMBER			Number of days prior to the expiration of the quotation that you want to be notified
VENDOR_DOC_NUM	VARCHAR2	(25)		Supplier document number
APPROVAL_REQUIRED_FLAG	VARCHAR2	(1)		Indicates if a RFQ requires approval
VENDOR_LIST	VARCHAR2	(25)		Supplier list name
VENDOR_LIST_HEADER_ID	NUMBER			Supplier list unique identifier
FROM_HEADER_ID	NUMBER			Unique identifier of the RFQ used to autocreate a quotation
FROM_TYPE_LOOKUP_CODE	VARCHAR2	(25)		Document type used to autocreate from
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		United States standard general ledger transaction code
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER			Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
REFERENCE_NUM	VARCHAR2	(25)		Needed for 832 EDI transaction
LOAD_SOURCING_RULES_FLAG	VARCHAR2	(1)		Needed for 832 EDI transaction
VENDOR_NUM	VARCHAR2	(30)		Needed for 832 EDI transaction
FROM_RFQ_NUM	VARCHAR2	(25)		Needed for 832 EDI transaction
WF_GROUP_ID	NUMBER			Identifies the records that were created during one run of the PO Create Documents workflow
PCARD_ID	NUMBER	(15)		Unique identifer for the procurement card used for the order
PAY_ON_CODE	VARCHAR2	(25)		Indicator of whether the purchase order will be paid upon receipt
GLOBAL_AGREEMENT_FLAG	VARCHAR2	(1)		Global Agreement flag - future release
CONSUME_REQ_DEMAND_FLAG	VARCHAR2	(1)		Used by Oracle Sourcing- Tells whether user wanted to consume the req demand when creating a blanket
SHIPPING_CONTROL	VARCHAR2	(30)		Indicator of who is responsible for arranging transportation
ENCUMBRANCE_REQUIRED_FLAG	VARCHAR2	(1)		-- FPJ Encumbrance Rewrite project
AMOUNT_TO_ENCUMBER	NUMBER			-- FPJ Encumbrance Rewrite project
CHANGE_SUMMARY	VARCHAR2	(2000)		Description of changes made. This information is entered by the Buyer when submitting the document for approval and may be used in generating an amendment document.
BUDGET_ACCOUNT_SEGMENT1	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT2	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT3	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT4	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT5	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT6	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT7	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT8	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT9	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT10	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT11	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT12	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT13	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT14	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT15	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT16	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT17	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT18	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT19	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT20	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT21	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT22	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT23	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT24	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT25	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT26	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT27	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT28	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT29	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_SEGMENT30	VARCHAR2	(25)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT	VARCHAR2	(2000)		FPJ Encumbrance Rewrite.
BUDGET_ACCOUNT_ID	NUMBER			FPJ Encumbrance Rewrite.
GL_ENCUMBERED_DATE	DATE			FPJ Encumbrance Rewrite.
GL_ENCUMBERED_PERIOD_NAME	VARCHAR2	(15)		FPJ Encumbrance Rewrite.
CREATED_LANGUAGE	VARCHAR2	(4)		Language code in which the GBPA was created.
CPA_REFERENCE	NUMBER			This is to support the iP catalog upgrade for items that had a CPA reference prior to Release 12. This column is just for information purpose.
DRAFT_ID	NUMBER			Reference to the data in draft table
PROCESSING_ID	NUMBER			Identifier for records to be processed by a certain PDOI run
PROCESSING_ROUND_NUM	NUMBER			The round number within each PDOI process
ORIGINAL_PO_HEADER_ID	NUMBER			Document to be replaced. Used only when action='REPLACE'
STYLE_ID	NUMBER			Determines the Purchasing Style of the document.
STYLE_DISPLAY_NAME	VARCHAR2	(240)		Style Display Name

Query Text

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


SELECT INTERFACE_HEADER_ID
,      BATCH_ID
,      INTERFACE_SOURCE_CODE
,      PROCESS_CODE
,      ACTION
,      GROUP_CODE
,      ORG_ID
,      DOCUMENT_TYPE_CODE
,      DOCUMENT_SUBTYPE
,      DOCUMENT_NUM
,      PO_HEADER_ID
,      RELEASE_NUM
,      PO_RELEASE_ID
,      RELEASE_DATE
,      CURRENCY_CODE
,      RATE_TYPE
,      RATE_TYPE_CODE
,      RATE_DATE
,      RATE
,      AGENT_NAME
,      AGENT_ID
,      VENDOR_NAME
,      VENDOR_ID
,      VENDOR_SITE_CODE
,      VENDOR_SITE_ID
,      VENDOR_CONTACT
,      VENDOR_CONTACT_ID
,      SHIP_TO_LOCATION
,      SHIP_TO_LOCATION_ID
,      BILL_TO_LOCATION
,      BILL_TO_LOCATION_ID
,      PAYMENT_TERMS
,      TERMS_ID
,      FREIGHT_CARRIER
,      FOB
,      FREIGHT_TERMS
,      APPROVAL_STATUS
,      APPROVED_DATE
,      REVISED_DATE
,      REVISION_NUM
,      NOTE_TO_VENDOR
,      NOTE_TO_RECEIVER
,      CONFIRMING_ORDER_FLAG
,      COMMENTS
,      ACCEPTANCE_REQUIRED_FLAG
,      ACCEPTANCE_DUE_DATE
,      AMOUNT_AGREED
,      AMOUNT_LIMIT
,      MIN_RELEASE_AMOUNT
,      EFFECTIVE_DATE
,      EXPIRATION_DATE
,      PRINT_COUNT
,      PRINTED_DATE
,      FIRM_FLAG
,      FROZEN_FLAG
,      CLOSED_CODE
,      CLOSED_DATE
,      REPLY_DATE
,      REPLY_METHOD
,      RFQ_CLOSE_DATE
,      QUOTE_WARNING_DELAY
,      VENDOR_DOC_NUM
,      APPROVAL_REQUIRED_FLAG
,      VENDOR_LIST
,      VENDOR_LIST_HEADER_ID
,      FROM_HEADER_ID
,      FROM_TYPE_LOOKUP_CODE
,      USSGL_TRANSACTION_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REFERENCE_NUM
,      LOAD_SOURCING_RULES_FLAG
,      VENDOR_NUM
,      FROM_RFQ_NUM
,      WF_GROUP_ID
,      PCARD_ID
,      PAY_ON_CODE
,      GLOBAL_AGREEMENT_FLAG
,      CONSUME_REQ_DEMAND_FLAG
,      SHIPPING_CONTROL
,      ENCUMBRANCE_REQUIRED_FLAG
,      AMOUNT_TO_ENCUMBER
,      CHANGE_SUMMARY
,      BUDGET_ACCOUNT_SEGMENT1
,      BUDGET_ACCOUNT_SEGMENT2
,      BUDGET_ACCOUNT_SEGMENT3
,      BUDGET_ACCOUNT_SEGMENT4
,      BUDGET_ACCOUNT_SEGMENT5
,      BUDGET_ACCOUNT_SEGMENT6
,      BUDGET_ACCOUNT_SEGMENT7
,      BUDGET_ACCOUNT_SEGMENT8
,      BUDGET_ACCOUNT_SEGMENT9
,      BUDGET_ACCOUNT_SEGMENT10
,      BUDGET_ACCOUNT_SEGMENT11
,      BUDGET_ACCOUNT_SEGMENT12
,      BUDGET_ACCOUNT_SEGMENT13
,      BUDGET_ACCOUNT_SEGMENT14
,      BUDGET_ACCOUNT_SEGMENT15
,      BUDGET_ACCOUNT_SEGMENT16
,      BUDGET_ACCOUNT_SEGMENT17
,      BUDGET_ACCOUNT_SEGMENT18
,      BUDGET_ACCOUNT_SEGMENT19
,      BUDGET_ACCOUNT_SEGMENT20
,      BUDGET_ACCOUNT_SEGMENT21
,      BUDGET_ACCOUNT_SEGMENT22
,      BUDGET_ACCOUNT_SEGMENT23
,      BUDGET_ACCOUNT_SEGMENT24
,      BUDGET_ACCOUNT_SEGMENT25
,      BUDGET_ACCOUNT_SEGMENT26
,      BUDGET_ACCOUNT_SEGMENT27
,      BUDGET_ACCOUNT_SEGMENT28
,      BUDGET_ACCOUNT_SEGMENT29
,      BUDGET_ACCOUNT_SEGMENT30
,      BUDGET_ACCOUNT
,      BUDGET_ACCOUNT_ID
,      GL_ENCUMBERED_DATE
,      GL_ENCUMBERED_PERIOD_NAME
,      CREATED_LANGUAGE
,      CPA_REFERENCE
,      DRAFT_ID
,      PROCESSING_ID
,      PROCESSING_ROUND_NUM
,      ORIGINAL_PO_HEADER_ID
,      STYLE_ID
,      STYLE_DISPLAY_NAME
FROM PO.PO_HEADERS_INTERFACE;

Dependencies

[top of page]

PO.PO_HEADERS_INTERFACE does not reference any database object

PO.PO_HEADERS_INTERFACE is referenced by following:

APPS: PO_HEADERS_INTERFACE