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


TABLE: PO.PO_HEADERS_ALL

Object Details
Object Name: PO_HEADERS_ALL
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_HEADERS_ALL
Subobject Name:
Status: VALID


PO_HEADERS_ALL contains header information for your purchasing
documents.
You need one row for each document you create. There are six types of
documents that use PO_HEADERS_ALL:
.
{{"bul:1"}}RFQs
.
{{"bul:1"}}Quotations
.
{{"bul:1"}}Standard purchase orders
.
{{"bul:1"}}Planned purchase orders
.
{{"bul:1"}}Blanket purchase orders
.
{{"bul:1"}}Contracts
.
{{"bodytext"}}Each row contains buyer information, supplier
information, brief notes, foreign currency information, terms and
conditions information, and the status of the document.
.
Oracle Purchasing uses this information to record information that is
related to a complete document.
.
PO_HEADER_ID is the unique system-generated primary key and is
invisible to the user. SEGMENT1 is the system-assigned number you use
to identify the document in forms and reports. Oracle Purchasing
generates SEGMENT1 using the PO_UNIQUE_IDENTIFIER_CONT_ALL table if
you choose to let Oracle Purchasing generate document numbers for you.
SEGMENT1 is not unique for the entire table. Different document types
can share the same numbers. You can uniquely identify a row in
PO_HEADERS_ALL using ORG_ID, SEGMENT1, and TYPE_LOOKUP_CODE, or using
PO_HEADER_ID.
.
If APPROVED_FLAG is 'Y', the purchase order is approved. If your
document type is a blanket purchase order, contract purchase order,
RFQ, or quotation, Oracle Purchasing uses START_DATE and END_DATE to
store the valid date range for the document. Oracle Purchasing only
uses BLANKET_TOTAL_AMOUNT for blanket purchase orders or contract
purchase orders.
.
If you autocreate a quotation from an RFQ using the Copy Document window,
Oracle Purchasing stores the foreign key to your original RFQ in
FROM_HEADER_ID. Oracle Purchasing also uses FROM_TYPE_LOOKUP_CODE to
indicate that you copied the quotation from an RFQ.
.
Oracle Purchasing does not use SUMMARY_FLAG and ENABLED_FLAG. Because
future versions of Oracle Purchasing will use them, SUMMARY_FLAG and
ENABLED_FLAG should always be 'N' and 'Y' respectively.
.
You enter document header information in the Header region of the
Purchase Orders, RFQs, and Quotations windows.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_HEADER_ID
PO_HEADERS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSEGMENT1
ColumnTYPE_LOOKUP_CODE
ColumnORG_ID
PO_HEADERS_F1 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDECODE("CONSIGNED_CONSUMPTION_FLAG",'Y',DECODE("CLOSED_CODE",'FINALLY CLOSED',NULL,'Y'),NULL)
PO_HEADERS_F2 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNVL("AUTHORIZATION_STATUS",'INCOMPLETE')
PO_HEADERS_F3 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPPER("SEGMENT1")
PO_HEADERS_F5 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNVL("CLM_DOCUMENT_NUMBER","SEGMENT1")
PO_HEADERS_F6 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPPER(NVL("CLM_DOCUMENT_NUMBER","SEGMENT1"))
PO_HEADERS_F7 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDECODE(RTRIM("SEGMENT1",'0123456789'),NULL,TO_NUMBER("SEGMENT1"),(-1))
PO_HEADERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_ID
ColumnVENDOR_SITE_ID
ColumnTYPE_LOOKUP_CODE
PO_HEADERS_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTYLE_ID
PO_HEADERS_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUTHORIZATION_STATUS
PO_HEADERS_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENCUMBRANCE_REQUIRED_FLAG
PO_HEADERS_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUDA_TEMPLATE_ID
PO_HEADERS_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAME_APPROVAL_ID
PO_HEADERS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREATION_DATE
PO_HEADERS_N20 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOTM_RECOVERY_FLAG
PO_HEADERS_N21 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLM_DOCUMENT_NUMBER
PO_HEADERS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAGENT_ID
ColumnAUTHORIZATION_STATUS
PO_HEADERS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFROM_HEADER_ID
PO_HEADERS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWF_ITEM_TYPE
ColumnWF_ITEM_KEY
PO_HEADERS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLOSED_DATE
PO_HEADERS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnQUOTE_VENDOR_QUOTE_NUMBER
PO_HEADERS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_ORDER_NUM
PO_HEADERS_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Yes Document header unique identifier
AGENT_ID NUMBER (9) Yes Buyer unique identifier. (References PO_AGENTS.agent_id)
TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Type of the document. (Combined with segment1and org_id to form unique key; References PO_DOCUMENT_TYPES_ALL_B.document_subtype)
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SEGMENT1 VARCHAR2 (20) Yes Key flexfield segment
SUMMARY_FLAG VARCHAR2 (1) Yes Key Flexfield summary flag
ENABLED_FLAG VARCHAR2 (1) Yes Key Flexfield enabled flag
SEGMENT2 VARCHAR2 (20)
Key flexfield segment
SEGMENT3 VARCHAR2 (20)
Key flexfield segment
SEGMENT4 VARCHAR2 (20)
Key flexfield segment
SEGMENT5 VARCHAR2 (20)
Key flexfield segment
START_DATE_ACTIVE DATE

Key Flexfield start date
END_DATE_ACTIVE DATE

Key Flexfield end date
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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).
VENDOR_ID NUMBER

Supplier unique identifier (References PO_VENDORS.vendor_id)
VENDOR_SITE_ID NUMBER

Supplier site unique identifier (References PO_VENDOR_SITES_ALL.vendor_site_id)
VENDOR_CONTACT_ID NUMBER

Supplier contact unique identifier (References PO_VENDOR_CONTACTS.vendor_contact_id)
SHIP_TO_LOCATION_ID NUMBER

Ship-to location unique identifier (References HR_LOCATIONS_ALL.location_id)
BILL_TO_LOCATION_ID NUMBER

Bill-to location unique identifier (References HR_LOCATIONS_ALL.location_id)
TERMS_ID NUMBER

Payment terms unique identifier (References to AP_TERMS_TL.term_id)
SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
Type of carrier to be used (References ORG_FREIGHT_TL.freight_code)
FOB_LOOKUP_CODE VARCHAR2 (25)
Type of free-on-board terms for the document (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FOB')
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)
Type of freight terms for the document (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FREIGHT TERMS')
STATUS_LOOKUP_CODE VARCHAR2 (25)
Status of the RFQ or Quotation (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='RFQ/QUOTE STATUS')
CURRENCY_CODE VARCHAR2 (15)
Unique identifier for the currency (References FND_CURRENCIES.currency_code)
RATE_TYPE VARCHAR2 (30)
Currency conversion rate type (References GL_DAILY_CONVERSION_TYPES.conversion_type)
RATE_DATE DATE

Currency conversion date
RATE NUMBER

Currency conversion rate
FROM_HEADER_ID NUMBER

Unique identifier of the quotation (standard or planned POs only) or global agreement (standard POs only) referenced by this line (References PO_HEADERS_ALL.po_header_id)
FROM_TYPE_LOOKUP_CODE VARCHAR2 (25)
Document type of the document used to autocreate another document (References: PO_DOCUMENT_TYPES_ALL_B.document_subtype)
START_DATE DATE

Effective date of the document
END_DATE DATE

Expiration date of the document
BLANKET_TOTAL_AMOUNT NUMBER

Amount agreed for the planned or blanket purchase order
AUTHORIZATION_STATUS VARCHAR2 (25)
Authorization status of the purchase order (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='AUTHORIZATION STATUS')
REVISION_NUM NUMBER

Document revision number
REVISED_DATE DATE

Date the document was last revised
APPROVED_FLAG VARCHAR2 (1)
Indicates whether the purchase order is approved or not
APPROVED_DATE DATE

Date the purchase order was last approved
AMOUNT_LIMIT NUMBER

Blanket, Planned PO or Contract only: Maximum amount that can be released
MIN_RELEASE_AMOUNT NUMBER

Minimum amount that can be released against a blanket or planned purchase order
NOTE_TO_AUTHORIZER VARCHAR2 (240)
Not currently used
NOTE_TO_VENDOR VARCHAR2 (480)
Note to the supplier
NOTE_TO_RECEIVER VARCHAR2 (480)
Note to the receiver of the purchase order
PRINT_COUNT NUMBER

Number of times the document was printed
PRINTED_DATE DATE

Date the document was last printed
VENDOR_ORDER_NUM VARCHAR2 (25)
Indicates supplier document number, it gets copied from PO_HEADERS_INTERFACE.vendor_doc_num
CONFIRMING_ORDER_FLAG VARCHAR2 (1)
Indicates whether the purchase order is a confirming order or not
COMMENTS VARCHAR2 (240)
Descriptive comments for the document
REPLY_DATE DATE

RFQ and Quotation only: Date the supplier replied to the RFQ
REPLY_METHOD_LOOKUP_CODE VARCHAR2 (25)
RFQ and Quotation only: Method the supplier should use to reply to the RFQ
RFQ_CLOSE_DATE DATE

RFQ and Quotation only: Date the RFQ will be closed
QUOTE_TYPE_LOOKUP_CODE VARCHAR2 (25)
RFQ and Quotation only: Type of quotation (References PO_DOCUMENT_TYPES_ALL_B.document_subtype)
QUOTATION_CLASS_CODE VARCHAR2 (25)
RFQ and Quotation only: Class of quotation
QUOTE_WARNING_DELAY_UNIT VARCHAR2 (25)
Warning delay unit of measure (Unused since release 7.0)
QUOTE_WARNING_DELAY NUMBER

Quotation only: Number of days prior to the expiration of the quotation that you want to be notified
QUOTE_VENDOR_QUOTE_NUMBER VARCHAR2 (25)
Quotation only: Number of the quotation for the supplier
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
CLOSED_DATE DATE

Date the document was closed
USER_HOLD_FLAG VARCHAR2 (1)
Indicates whether the purchase order is on hold or not
APPROVAL_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether a quote or RFQ requires approval
CANCEL_FLAG VARCHAR2 (1)
Indicates whether the purchase order is cancelled or not
FIRM_STATUS_LOOKUP_CODE VARCHAR2 (30)
Indicates whether you want to prevent this purchase order from being automatically rescheduled by your manufacturing application
FIRM_DATE DATE

Date from which the purchase order is firmed
FROZEN_FLAG VARCHAR2 (1)
Indicates whether the document is frozen or not
SUPPLY_AGREEMENT_FLAG VARCHAR2 (1)
Supply agreement flag for Supplier Scheduling
EDI_PROCESSED_FLAG VARCHAR2 (1)
EDI processed flag
EDI_PROCESSED_STATUS VARCHAR2 (10)
EDI processing status flag
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
CLOSED_CODE VARCHAR2 (25)
Describes the closure status of the document (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='DOCUMENT STATE')
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code (References GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE)
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
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).
ORG_ID NUMBER

Organization identifier
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
INTERFACE_SOURCE_CODE VARCHAR2 (25)
Audit trail reference (needed for 832 EDI transaction)
REFERENCE_NUM VARCHAR2 (25)
Audit trail reference (needed for 832 EDI transaction)
WF_ITEM_TYPE VARCHAR2 (8)
Workflow approval item type (References WF_ITEMS.item_type)
WF_ITEM_KEY VARCHAR2 (240)
Workflow approval item key (References WF_ITEMS.item_key)
MRC_RATE_TYPE VARCHAR2 (2000)
Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID and currency conversion rate type pairs
MRC_RATE_DATE VARCHAR2 (2000)
Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID and currency conversion date pairs
MRC_RATE VARCHAR2 (2000)
Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID and currency conversion rate pairs
PCARD_ID NUMBER (15)
Unique identifer for the procurement card used for the order (References AP_CARDS_ALL.card_id)
PRICE_UPDATE_TOLERANCE NUMBER

Maximum percentage increase allowed in price/sales catalog update (832 EDI transaction) sent by supplier
PAY_ON_CODE VARCHAR2 (25)
Indicator of whether the purchase order will be paid upon receipt (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='PAY ON CODE')
XML_FLAG VARCHAR2 (3)
Indicator whether the delivery option is through XML. Y if so.
XML_SEND_DATE DATE

Date on which XML document is created, if XML delivery is used.
XML_CHANGE_SEND_DATE DATE

Date on which the po change XML document generation date, if delivery option is XML.
GLOBAL_AGREEMENT_FLAG VARCHAR2 (1)
Global agreement flag
CONSIGNED_CONSUMPTION_FLAG VARCHAR2 (1)
Flag indicates that the purchase order is a consumption advice
CBC_ACCOUNTING_DATE DATE

Column used to store the accounting action date for dual budgetary control functionality.
CONSUME_REQ_DEMAND_FLAG VARCHAR2 (1)
Used by Oracle Sourcing- Tells whether user wanted to consume the req demand when creating a blanket
CHANGE_REQUESTED_BY VARCHAR2 (20)
Change Requested By will track changes to Purchase Document from Supplier/ Requester
SHIPPING_CONTROL VARCHAR2 (30)
Indicator of who is responsible for arranging transportation (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='SHIPPING CONTROL')
CONTERMS_EXIST_FLAG VARCHAR2 (1)
Indicates if contract terms template is attached to the purchasing document or not. Applicable to Purchasing document of type Standard, Contract, Blanket
CONTERMS_ARTICLES_UPD_DATE DATE

Timestamp for the last update to Contract Clauses. Applicable to Purchasing document of type Standard, Contract, Blanket
CONTERMS_DELIV_UPD_DATE DATE

Timestamp for the last update to Contract Deliverables. Applicable to Purchasing document of type Standard, Contract, Blanket
ENCUMBRANCE_REQUIRED_FLAG VARCHAR2 (1)
Blanket or Global Agreement only: Indicates whether the document is to be encumbred or not
PENDING_SIGNATURE_FLAG VARCHAR2 (1)
Indicates if the purchasing document is waiting for the signatures or not. Applicable to Purchasing document of type Standard, Contract, Blanket
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.
DOCUMENT_CREATION_METHOD VARCHAR2 (30)
Method in which the document got created - Autocreate, enter PO , etc...
SUBMIT_DATE DATE

Date when document was first submitted for approval
SUPPLIER_NOTIF_METHOD VARCHAR2 (25)
Supplier Notification Method
FAX VARCHAR2 (30)
Supplier Fax Number
EMAIL_ADDRESS VARCHAR2 (2000)
Supplier Email Address
RETRO_PRICE_COMM_UPDATES_FLAG VARCHAR2 (1)
Communicate price updates flag
RETRO_PRICE_APPLY_UPDATES_FLAG VARCHAR2 (1)
Retroactively apply price updates to existing POs flag.
UPDATE_SOURCING_RULES_FLAG VARCHAR2 (1)
Update sourcing rules flag
AUTO_SOURCING_FLAG VARCHAR2 (1)
Enable automatic sourcing flag
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.
LOCK_OWNER_ROLE VARCHAR2 (10)
Role of the user locking the document
LOCK_OWNER_USER_ID NUMBER

User who is locking the document
SUPPLIER_AUTH_ENABLED_FLAG VARCHAR2 (1)
Supplier Auth Enabled Flag
CAT_ADMIN_AUTH_ENABLED_FLAG VARCHAR2 (1)
Cat Admin Auth Enabled Flag
STYLE_ID NUMBER
Yes Determines the Purchasing Style of the document.
TAX_ATTRIBUTE_UPDATE_CODE VARCHAR2 (15)
Keeps track of create/update actions on this entity
LAST_UPDATED_PROGRAM VARCHAR2 (255)
The program name that last updated the row.
ENABLE_ALL_SITES VARCHAR2 (1)
Enable all the vendor sites for this GPBA
PAY_WHEN_PAID VARCHAR2 (1)
This is done as a part of E&C ER- Phase 1
COMM_REV_NUM NUMBER

Comm Revision number
CLM_DOCUMENT_NUMBER VARCHAR2 (50)
Unique Document Number for the user
OTM_STATUS_CODE VARCHAR2 (80)
Status of OTM Communication
OTM_RECOVERY_FLAG VARCHAR2 (1)
Flag to indicate whether OTM communication needs to be recovered
UDA_TEMPLATE_ID NUMBER

Uda Template id
UDA_TEMPLATE_DATE DATE

Uda Template date
USER_DOCUMENT_STATUS VARCHAR2 (30)
User extensible status
AME_APPROVAL_ID NUMBER

Unique identifier for approval transaction
DRAFT_ID NUMBER

Dummy attribute for UDA
CLM_EFFECTIVE_DATE DATE

Effective Date of the Document
CLM_VENDOR_OFFER_NUMBER VARCHAR2 (400)
Vendor Offer number
CLM_AWARD_ADMINISTRATOR VARCHAR2 (400)
Administrator for the Document.
CLM_NO_SIGNED_COPIES_TO_RETURN NUMBER

Number of Signed copies to return
CLM_MIN_GUARANTEE_AWARD_AMT NUMBER

Minimum amount that can be guaranteed on a CLM document.
CLM_MIN_GUAR_AWARD_AMT_PERCENT NUMBER

Percentage of minimun amount guaranteed on the CLM award.
CLM_MIN_ORDER_AMOUNT NUMBER

Minimum Order Amount used for Ordering Constraints
CLM_MAX_ORDER_AMOUNT NUMBER

Maximum Order Amount used for Ordering Constraints
CLM_AMT_SYNCED_TO_AGREEMENT VARCHAR2 (1)
Amount synched onto the agreement.
CLM_AMOUNT_RELEASED NUMBER

Amount Released.
CLM_EXTERNAL_IDV VARCHAR2 (2000)
External System IDV Number
CLM_SUPPLIER_NAME VARCHAR2 (400)
Supplier Name - Denormalised
CLM_SUPPLIER_SITE_NAME VARCHAR2 (400)
Supplier Site Name - Denormalised
CLM_SOURCE_DOCUMENT_ID NUMBER

Sourcing Document id
CLM_ISSUING_OFFICE VARCHAR2 (1000)
CLM Issuing Office.
CLM_COTR_OFFICE VARCHAR2 (2000)
CLM COTR Office.
CLM_COTR_CONTACT VARCHAR2 (200)
Contact of COTR.
CLM_PRIORITY_CODE VARCHAR2 (200)
Maintains the CLM priority code.
CLM_MOD_ISSUING_OFFICE VARCHAR2 (1000)
Modification issuing office.
CLM_STANDARD_FORM VARCHAR2 (200)
Standard Form code for PDF generation
CLM_DOCUMENT_FORMAT VARCHAR2 (200)
Document Format code for PDF generation
AME_TRANSACTION_TYPE VARCHAR2 (50)
AME Transaction Type used for the Document approval
CLM_AWARD_TYPE VARCHAR2 (100)
Type of Award
CLM_CONTRACT_OFFICER NUMBER

Contracting Officer of the document
CLM_CLOSEOUT_STATUS VARCHAR2 (25)
Closeout status for CLM Documents
UMBRELLA_PROGRAM_ID NUMBER

Stores the Umbrella program reference to PON_UMBRELLA_PROGRAMS table
FON_REF_ID NUMBER

Stores the Fair Opportunity Notice reference to PON_AUCTION_HEADERS_ALL table
CLM_DEFAULT_DIST_FLAG VARCHAR2 (1)
Flag to indicate whether Distributions should default automatically for CLM Documents
CLM_EDAGEN_DATE DATE

Stores the date on which the EDA was generated
CLM_CONTRACT_FINANCE_CODE VARCHAR2 (30)
CLM_PAYMENT_INSTR_CODE VARCHAR2 (30)
CLM_SPECIAL_CONTRACT_TYPE VARCHAR2 (30)
Query Text

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


SELECT PO_HEADER_ID
,      AGENT_ID
,      TYPE_LOOKUP_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SEGMENT1
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      SHIP_TO_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      TERMS_ID
,      SHIP_VIA_LOOKUP_CODE
,      FOB_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      STATUS_LOOKUP_CODE
,      CURRENCY_CODE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      FROM_HEADER_ID
,      FROM_TYPE_LOOKUP_CODE
,      START_DATE
,      END_DATE
,      BLANKET_TOTAL_AMOUNT
,      AUTHORIZATION_STATUS
,      REVISION_NUM
,      REVISED_DATE
,      APPROVED_FLAG
,      APPROVED_DATE
,      AMOUNT_LIMIT
,      MIN_RELEASE_AMOUNT
,      NOTE_TO_AUTHORIZER
,      NOTE_TO_VENDOR
,      NOTE_TO_RECEIVER
,      PRINT_COUNT
,      PRINTED_DATE
,      VENDOR_ORDER_NUM
,      CONFIRMING_ORDER_FLAG
,      COMMENTS
,      REPLY_DATE
,      REPLY_METHOD_LOOKUP_CODE
,      RFQ_CLOSE_DATE
,      QUOTE_TYPE_LOOKUP_CODE
,      QUOTATION_CLASS_CODE
,      QUOTE_WARNING_DELAY_UNIT
,      QUOTE_WARNING_DELAY
,      QUOTE_VENDOR_QUOTE_NUMBER
,      ACCEPTANCE_REQUIRED_FLAG
,      ACCEPTANCE_DUE_DATE
,      CLOSED_DATE
,      USER_HOLD_FLAG
,      APPROVAL_REQUIRED_FLAG
,      CANCEL_FLAG
,      FIRM_STATUS_LOOKUP_CODE
,      FIRM_DATE
,      FROZEN_FLAG
,      SUPPLY_AGREEMENT_FLAG
,      EDI_PROCESSED_FLAG
,      EDI_PROCESSED_STATUS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CLOSED_CODE
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      INTERFACE_SOURCE_CODE
,      REFERENCE_NUM
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      MRC_RATE_TYPE
,      MRC_RATE_DATE
,      MRC_RATE
,      PCARD_ID
,      PRICE_UPDATE_TOLERANCE
,      PAY_ON_CODE
,      XML_FLAG
,      XML_SEND_DATE
,      XML_CHANGE_SEND_DATE
,      GLOBAL_AGREEMENT_FLAG
,      CONSIGNED_CONSUMPTION_FLAG
,      CBC_ACCOUNTING_DATE
,      CONSUME_REQ_DEMAND_FLAG
,      CHANGE_REQUESTED_BY
,      SHIPPING_CONTROL
,      CONTERMS_EXIST_FLAG
,      CONTERMS_ARTICLES_UPD_DATE
,      CONTERMS_DELIV_UPD_DATE
,      ENCUMBRANCE_REQUIRED_FLAG
,      PENDING_SIGNATURE_FLAG
,      CHANGE_SUMMARY
,      DOCUMENT_CREATION_METHOD
,      SUBMIT_DATE
,      SUPPLIER_NOTIF_METHOD
,      FAX
,      EMAIL_ADDRESS
,      RETRO_PRICE_COMM_UPDATES_FLAG
,      RETRO_PRICE_APPLY_UPDATES_FLAG
,      UPDATE_SOURCING_RULES_FLAG
,      AUTO_SOURCING_FLAG
,      CREATED_LANGUAGE
,      CPA_REFERENCE
,      LOCK_OWNER_ROLE
,      LOCK_OWNER_USER_ID
,      SUPPLIER_AUTH_ENABLED_FLAG
,      CAT_ADMIN_AUTH_ENABLED_FLAG
,      STYLE_ID
,      TAX_ATTRIBUTE_UPDATE_CODE
,      LAST_UPDATED_PROGRAM
,      ENABLE_ALL_SITES
,      PAY_WHEN_PAID
,      COMM_REV_NUM
,      CLM_DOCUMENT_NUMBER
,      OTM_STATUS_CODE
,      OTM_RECOVERY_FLAG
,      UDA_TEMPLATE_ID
,      UDA_TEMPLATE_DATE
,      USER_DOCUMENT_STATUS
,      AME_APPROVAL_ID
,      DRAFT_ID
,      CLM_EFFECTIVE_DATE
,      CLM_VENDOR_OFFER_NUMBER
,      CLM_AWARD_ADMINISTRATOR
,      CLM_NO_SIGNED_COPIES_TO_RETURN
,      CLM_MIN_GUARANTEE_AWARD_AMT
,      CLM_MIN_GUAR_AWARD_AMT_PERCENT
,      CLM_MIN_ORDER_AMOUNT
,      CLM_MAX_ORDER_AMOUNT
,      CLM_AMT_SYNCED_TO_AGREEMENT
,      CLM_AMOUNT_RELEASED
,      CLM_EXTERNAL_IDV
,      CLM_SUPPLIER_NAME
,      CLM_SUPPLIER_SITE_NAME
,      CLM_SOURCE_DOCUMENT_ID
,      CLM_ISSUING_OFFICE
,      CLM_COTR_OFFICE
,      CLM_COTR_CONTACT
,      CLM_PRIORITY_CODE
,      CLM_MOD_ISSUING_OFFICE
,      CLM_STANDARD_FORM
,      CLM_DOCUMENT_FORMAT
,      AME_TRANSACTION_TYPE
,      CLM_AWARD_TYPE
,      CLM_CONTRACT_OFFICER
,      CLM_CLOSEOUT_STATUS
,      UMBRELLA_PROGRAM_ID
,      FON_REF_ID
,      CLM_DEFAULT_DIST_FLAG
,      CLM_EDAGEN_DATE
,      CLM_CONTRACT_FINANCE_CODE
,      CLM_PAYMENT_INSTR_CODE
,      CLM_SPECIAL_CONTRACT_TYPE
FROM PO.PO_HEADERS_ALL;

Dependencies

[top of page]

PO.PO_HEADERS_ALL does not reference any database object

PO.PO_HEADERS_ALL is referenced by following:

SchemaPO
ViewPO_HEADERS_ALL#