[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_HEADERS_XML |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PO.PO_HEADERS_XML
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| 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) |
| SEGMENT1 | VARCHAR2 | (20) | Yes | Key flexfield segment |
| REVISION_NUM | NUMBER | Document revision number | ||
| PRINT_COUNT | NUMBER | Number of times the document was printed | ||
| CREATION_DATE | VARCHAR2 | (20) | Standard who column - date when this row was created. | |
| PRINTED_DATE | DATE | Date the document was last printed | ||
| REVISED_DATE | VARCHAR2 | (20) | Date the document was last revised | |
| START_DATE | VARCHAR2 | (20) | Effective date of the document | |
| END_DATE | VARCHAR2 | (20) | Expiration date of the document | |
| NOTE_TO_VENDOR | VARCHAR2 | (480) | Note to the supplier | |
| DOCUMENT_BUYER_FIRST_NAME | VARCHAR2 | (150) | Buyer's first name References PER_ALL_PEOPLE_F.first_name | |
| DOCUMENT_BUYER_LAST_NAME | VARCHAR2 | (150) | Yes | Buyer's last name References PER_ALL_PEOPLE_F.last_name |
| DOCUMENT_BUYER_TITLE | VARCHAR2 | (30) | Buyer's title References PER_ALL_PEOPLE_F.title | |
| DOCUMENT_BUYER_AGENT_ID | NUMBER | (9) | Yes | Buyer unique identifier. (References PO_AGENTS.agent_id) |
| ARCHIVE_BUYER_AGENT_ID | VARCHAR2 | (40) | Agent ID of Buyer of zero'th revision of the document. Agent Id is null if PO revision_num is 0. | |
| ARCHIVE_BUYER_FIRST_NAME | VARCHAR2 | (4000) | First name of Buyer of zero'th revision of the document.NULL if PO revision_num is 0. | |
| ARCHIVE_BUYER_LAST_NAME | VARCHAR2 | (4000) | Last name of Buyer of zero'th revision of the document. Null if PO revision_num is 0. | |
| ARCHIVE_BUYER_TITLE | VARCHAR2 | (4000) | Last name of Buyer of zero'th revision of the document. Null if PO revision_num is 0. | |
| AMOUNT_AGREED | VARCHAR2 | (4000) | Amount agreed for the planned or blanket purchase order | |
| CANCEL_FLAG | VARCHAR2 | (1) | Indicates whether the purchase order is cancelled or not | |
| CONFIRMING_ORDER_FLAG | VARCHAR2 | (1) | Indicates whether the purchase order is a confirming order or not | |
| ACCEPTANCE_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether acceptance from the supplier is required or not | |
| ACCEPTANCE_DUE_DATE | VARCHAR2 | (20) | Date by which the supplier should accept the purchase order | |
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | Unique identifier for the currency (References FND_CURRENCIES.currency_code) |
| CURRENCY_NAME | VARCHAR2 | (80) | Yes | Name of the currency. References FND_CURRENCIES_VL.name |
| RATE | VARCHAR2 | (4000) | Currency conversion rate | |
| SHIP_VIA | VARCHAR2 | (25) | Type of carrier to be used (References ORG_FREIGHT_TL.freight_code) | |
| FOB | VARCHAR2 | (80) | Type of free-on-board terms for the document (References FND_LOOKUP_VALUES.meaning with LOOKUP_TYPE='FOB') | |
| FREIGHT_TERMS | VARCHAR2 | (80) | Type of free-on-board terms for the document (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FOB') | |
| PAYMENT_TERMS | VARCHAR2 | (50) | Type of PAYMENT terms for the document (References AP_TERMS.NAME | |
| CUSTOMER_NUM | VARCHAR2 | (25) | Customer account number. References po_vendor_sites_all.customer_num or po_vendors.customer_num. | |
| VENDOR_NUM | VARCHAR2 | (30) | Supplier number. References po_vendors.SEGMENT1 | |
| VENDOR_NAME | VARCHAR2 | (240) | Supplier name. References po_vendors.name | |
| VENDOR_ADDRESS_LINE1 | VARCHAR2 | (240) | Supplier address line 1. References po_vendor_sites_all.address_line1 | |
| VENDOR_ADDRESS_LINE2 | VARCHAR2 | (240) | Supplier address line 2. References po_vendor_sites_all.address_line2 | |
| VENDOR_ADDRESS_LINE3 | VARCHAR2 | (240) | Supplier address line 3. References po_vendor_sites_all.address_line3 | |
| VENDOR_CITY | VARCHAR2 | (25) | Supplier city. References po_vendor_sites_all.city | |
| VENDOR_STATE | VARCHAR2 | (150) | Supplier state. References po_vendor_sites_all.state or county or province | |
| VENDOR_POSTAL_CODE | VARCHAR2 | (20) | Supplier postal code. References po_vendor_sites_all.zip | |
| VENDOR_COUNTRY | VARCHAR2 | (80) | Supplier country. References FND_TERRITORIES_TL.TERRITORY_SHORT_NAME | |
| VENDOR_PHONE | VARCHAR2 | (15) | Supplier phone number. References po_vendor_sites_all.phone | |
| VENDOR_CONTACT_FIRST_NAME | VARCHAR2 | (15) | Supplier contact first name. References po_vendor_contacts.first_name | |
| VENDOR_CONTACT_LAST_NAME | VARCHAR2 | (15) | Supplier contact last name. References po_vendor_contacts.last_name | |
| VENDOR_CONTACT_TITLE | VARCHAR2 | (80) | Supplier contact title. References po_vendor_contacts.title | |
| VENDOR_CONTACT_PHONE | VARCHAR2 | (40) | Supplier contact phone. References po_vendor_contacts.phone | |
| SHIP_TO_LOCATION_ID | VARCHAR2 | (40) | Ship-to location unique identifier. | |
| SHIP_TO_LOCATION_NAME | VARCHAR2 | (4000) | Ship-to location name. | |
| SHIP_TO_ADDRESS_LINE1 | VARCHAR2 | (4000) | Ship-to location address first line. | |
| SHIP_TO_ADDRESS_LINE2 | VARCHAR2 | (4000) | Ship-to location address second line. | |
| SHIP_TO_ADDRESS_LINE3 | VARCHAR2 | (4000) | Ship-to location address third line. | |
| SHIP_TO_ADDRESS_LINE4 | VARCHAR2 | (4000) | Ship-to location address fourth line. | |
| SHIP_TO_ADDRESS_INFO | VARCHAR2 | (4000) | "This is the concatenation value of town_or_city, state_or_province and postal_code" | |
| SHIP_TO_COUNTRY | VARCHAR2 | (4000) | Ship-to location country. | |
| BILL_TO_LOCATION_ID | VARCHAR2 | (40) | Bill-to location unique identifier. | |
| BILL_TO_LOCATION_NAME | VARCHAR2 | (4000) | Bill-to location name. | |
| BILL_TO_ADDRESS_LINE1 | VARCHAR2 | (4000) | Bill-to location address first line. | |
| BILL_TO_ADDRESS_LINE2 | VARCHAR2 | (4000) | Bill-to location address second line. | |
| BILL_TO_ADDRESS_LINE3 | VARCHAR2 | (4000) | Bill-to location address third line. | |
| BILL_TO_ADDRESS_LINE4 | VARCHAR2 | (4000) | Bill-to location address fourth line | |
| BILL_TO_ADDRESS_INFO | VARCHAR2 | (4000) | "This is the concatenation value of town_or_city, state_or_province and postal_code" | |
| BILL_TO_COUNTRY | VARCHAR2 | (4000) | Bill-to location country. | |
| 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 | |
| VENDOR_SITE_ID | NUMBER | Supplier site unique identifier (References PO_VENDOR_SITES_ALL.vendor_site_id) | ||
| PO_HEADER_ID | NUMBER | Yes | Document header unique identifier | |
| APPROVED_FLAG | VARCHAR2 | (1) | Indicates whether the purchase order is approved or not | |
| LANGUAGE | VARCHAR2 | (30) | supplier language. Refers to po_vendor_sites_all.language | |
| VENDOR_ID | NUMBER | Supplier unique identifier (References PO_VENDORS.vendor_id) | ||
| 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 | ||
| COMMENTS | VARCHAR2 | (240) | Descriptive comments for the document | |
| REPLY_DATE | VARCHAR2 | (20) | 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 | VARCHAR2 | (20) | 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 | |
| CLOSED_DATE | VARCHAR2 | (20) | 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 | |
| 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 | VARCHAR2 | (20) | Date from which the purchase order is firmed | |
| FROZEN_FLAG | VARCHAR2 | (1) | Indicates whether the document is frozen or not | |
| 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. | |
| CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
| VENDOR_CONTACT_ID | NUMBER | Supplier contact unique identifier (References PO_VENDOR_CONTACTS.vendor_contact_id) | ||
| TERMS_ID | NUMBER | Payment terms unique identifier (References to AP_TERMS_TL.term_id) | ||
| 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 FND_LOOKUP_VALUES.meaning 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') | |
| RATE_TYPE | VARCHAR2 | (30) | Currency conversion rate type (References GL_DAILY_CONVERSION_TYPES.conversion_type) | |
| RATE_DATE | VARCHAR2 | (20) | Currency conversion date | |
| 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) | |
| AUTHORIZATION_STATUS | VARCHAR2 | (25) | Authorization status of the purchase order (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='AUTHORIZATION STATUS') | |
| APPROVED_DATE | VARCHAR2 | (20) | Date the purchase order was last approved | |
| AMOUNT_LIMIT | VARCHAR2 | (4000) | "Blanket, Planned PO or Contract only: Maximum amount that can be released" | |
| MIN_RELEASE_AMOUNT | VARCHAR2 | (4000) | Minimum amount that can be released against a blanket or planned purchase order | |
| NOTE_TO_AUTHORIZER | VARCHAR2 | (240) | Not currently used | |
| NOTE_TO_RECEIVER | VARCHAR2 | (480) | Note to the receiver of the purchase order | |
| VENDOR_ORDER_NUM | VARCHAR2 | (25) | "Indicates supplier document number, it gets copied from PO_HEADERS_INTERFACE.vendor_doc_num" | |
| LAST_UPDATE_DATE | VARCHAR2 | (20) | 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). | |
| 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 | VARCHAR2 | (20) | Key Flexfield start date | |
| END_DATE_ACTIVE | VARCHAR2 | (20) | 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). | ||
| SUPPLY_AGREEMENT_FLAG | VARCHAR2 | (1) | Supply agreement flag for Supplier Scheduling | |
| 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) | |
| PCARD_ID | NUMBER | (15) | Unique identifier 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 | ||
| 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 | |
| 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 | VARCHAR2 | (20) | "Date on which XML document is created, if XML delivery is used." | |
| XML_CHANGE_SEND_DATE | VARCHAR2 | (20) | "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 | VARCHAR2 | (20) | 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 | (80) | 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 | VARCHAR2 | (20) | "Timestamp for the last update to Contract Clauses. Applicable to Purchasing document of type Standard, Contract, Blanket" | |
| CONTERMS_DELIV_UPD_DATE | VARCHAR2 | (20) | "Timestamp for the last update to Contract Deliverables. Applicable to Purchasing document of type Standard, Contract, Blanket" | |
| 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" | |
| OU_NAME | VARCHAR2 | (4000) | Indicates Operating unit name. | |
| OU_ADDR1 | VARCHAR2 | (4000) | Holds Operating Unit address line 1. | |
| OU_ADDR2 | VARCHAR2 | (4000) | Holds Operating Unit address line 2. | |
| OU_ADDR3 | VARCHAR2 | (4000) | Holds Operating Unit address line 3. | |
| OU_TOWN_CITY | VARCHAR2 | (4000) | Holds Operating Unit town_or_city. | |
| OU_REGION2 | VARCHAR2 | (4000) | Holds Operating Unit state or province or county. | |
| OU_POSTALCODE | VARCHAR2 | (4000) | Holds Operating Unit postal code. | |
| OU_COUNTRY | VARCHAR2 | (4000) | Holds Operating Unit country. | |
| BUYER_LOCATION_ID | NUMBER | Buyer location unique identifier. References PO_AGENTS.location_id | ||
| BUYER_ADDRESS_LINE1 | VARCHAR2 | (4000) | Buyer address line 1. | |
| BUYER_ADDRESS_LINE2 | VARCHAR2 | (4000) | Buyer address line 2. | |
| BUYER_ADDRESS_LINE3 | VARCHAR2 | (4000) | Buyer address line 3. | |
| BUYER_ADDRESS_LINE4 | VARCHAR2 | (4000) | Buyer address line 4. | |
| BUYER_CITY_STATE_ZIP | VARCHAR2 | (4000) | "Concatenated value of Buyer city, state and zip." | |
| BUYER_CONTACT_PHONE | VARCHAR2 | (4000) | Buyer Contact phone. | |
| BUYER_CONTACT_EMAIL | VARCHAR2 | (4000) | Buyer Contact Email | |
| BUYER_CONTACT_FAX | VARCHAR2 | (4000) | Buyer Contact fax. | |
| VENDOR_FAX | VARCHAR2 | (15) | Supplier fax number. References po_vendor_sites_all.fax | |
| TOTAL_AMOUNT | VARCHAR2 | (4000) | Total amount of Standard Purchase Order. | |
| BUYER_COUNTRY | VARCHAR2 | (4000) | Buyer Country. | |
| VENDOR_ADDRESS_LINE4 | VARCHAR2 | (240) | Supplier address line 4. References po_vendor_sites_all.ADDRESS_LINE4 | |
| VENDOR_AREA_CODE | VARCHAR2 | (10) | Supplier phone area code. References po_vendor_sites_all.area_code | |
| VENDOR_CONTACT_AREA_CODE | VARCHAR2 | (10) | Supplier contact phone area code. References vendor_sites.area_code | |
| LE_NAME | VARCHAR2 | (4000) | Legal Entity name of the Organization. | |
| LE_ADDR1 | VARCHAR2 | (4000) | Legal Entity address line 1. | |
| LE_ADDR2 | VARCHAR2 | (4000) | Legal Entity address line 2. | |
| LE_ADDR3 | VARCHAR2 | (4000) | Legal Entity address line 3. | |
| LE_TOWN_CITY | VARCHAR2 | (4000) | Legal Entity town or city name. | |
| LE_STAE_PROVINCE | VARCHAR2 | (4000) | Legal Entity state or province. | |
| LE_POSTALCODE | VARCHAR2 | (4000) | Legal Entity postal code. | |
| LE_COUNTRY | VARCHAR2 | (4000) | Legal Entity country. | |
| CANCEL_DATE | DATE | Date the purchase order was cancelled | ||
| 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... | |
| ENCUMBRANCE_REQUIRED_FLAG | VARCHAR2 | (1) | Blanket or Global Agreement only: Indicates whether the document is to be encumbred or not | |
| STYLE_DISPLAY_NAME | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT TYPE_LOOKUP_CODE
, SEGMENT1
, REVISION_NUM
, PRINT_COUNT
, CREATION_DATE
, PRINTED_DATE
, REVISED_DATE
, START_DATE
, END_DATE
, NOTE_TO_VENDOR
, DOCUMENT_BUYER_FIRST_NAME
, DOCUMENT_BUYER_LAST_NAME
, DOCUMENT_BUYER_TITLE
, DOCUMENT_BUYER_AGENT_ID
, ARCHIVE_BUYER_AGENT_ID
, ARCHIVE_BUYER_FIRST_NAME
, ARCHIVE_BUYER_LAST_NAME
, ARCHIVE_BUYER_TITLE
, AMOUNT_AGREED
, CANCEL_FLAG
, CONFIRMING_ORDER_FLAG
, ACCEPTANCE_REQUIRED_FLAG
, ACCEPTANCE_DUE_DATE
, CURRENCY_CODE
, CURRENCY_NAME
, RATE
, SHIP_VIA
, FOB
, FREIGHT_TERMS
, PAYMENT_TERMS
, CUSTOMER_NUM
, VENDOR_NUM
, VENDOR_NAME
, VENDOR_ADDRESS_LINE1
, VENDOR_ADDRESS_LINE2
, VENDOR_ADDRESS_LINE3
, VENDOR_CITY
, VENDOR_STATE
, VENDOR_POSTAL_CODE
, VENDOR_COUNTRY
, VENDOR_PHONE
, VENDOR_CONTACT_FIRST_NAME
, VENDOR_CONTACT_LAST_NAME
, VENDOR_CONTACT_TITLE
, VENDOR_CONTACT_PHONE
, SHIP_TO_LOCATION_ID
, SHIP_TO_LOCATION_NAME
, SHIP_TO_ADDRESS_LINE1
, SHIP_TO_ADDRESS_LINE2
, SHIP_TO_ADDRESS_LINE3
, SHIP_TO_ADDRESS_LINE4
, SHIP_TO_ADDRESS_INFO
, SHIP_TO_COUNTRY
, BILL_TO_LOCATION_ID
, BILL_TO_LOCATION_NAME
, BILL_TO_ADDRESS_LINE1
, BILL_TO_ADDRESS_LINE2
, BILL_TO_ADDRESS_LINE3
, BILL_TO_ADDRESS_LINE4
, BILL_TO_ADDRESS_INFO
, BILL_TO_COUNTRY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, VENDOR_SITE_ID
, PO_HEADER_ID
, APPROVED_FLAG
, LANGUAGE
, VENDOR_ID
, CLOSED_CODE
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, 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
, CLOSED_DATE
, USER_HOLD_FLAG
, APPROVAL_REQUIRED_FLAG
, FIRM_STATUS_LOOKUP_CODE
, FIRM_DATE
, FROZEN_FLAG
, EDI_PROCESSED_FLAG
, EDI_PROCESSED_STATUS
, ATTRIBUTE_CATEGORY
, CREATED_BY
, VENDOR_CONTACT_ID
, TERMS_ID
, FOB_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE
, STATUS_LOOKUP_CODE
, RATE_TYPE
, RATE_DATE
, FROM_HEADER_ID
, FROM_TYPE_LOOKUP_CODE
, AUTHORIZATION_STATUS
, APPROVED_DATE
, AMOUNT_LIMIT
, MIN_RELEASE_AMOUNT
, NOTE_TO_AUTHORIZER
, NOTE_TO_RECEIVER
, VENDOR_ORDER_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, SUMMARY_FLAG
, ENABLED_FLAG
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATE_LOGIN
, SUPPLY_AGREEMENT_FLAG
, 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
, PCARD_ID
, PRICE_UPDATE_TOLERANCE
, MRC_RATE_TYPE
, MRC_RATE_DATE
, MRC_RATE
, 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
, PENDING_SIGNATURE_FLAG
, OU_NAME
, OU_ADDR1
, OU_ADDR2
, OU_ADDR3
, OU_TOWN_CITY
, OU_REGION2
, OU_POSTALCODE
, OU_COUNTRY
, BUYER_LOCATION_ID
, BUYER_ADDRESS_LINE1
, BUYER_ADDRESS_LINE2
, BUYER_ADDRESS_LINE3
, BUYER_ADDRESS_LINE4
, BUYER_CITY_STATE_ZIP
, BUYER_CONTACT_PHONE
, BUYER_CONTACT_EMAIL
, BUYER_CONTACT_FAX
, VENDOR_FAX
, TOTAL_AMOUNT
, BUYER_COUNTRY
, VENDOR_ADDRESS_LINE4
, VENDOR_AREA_CODE
, VENDOR_CONTACT_AREA_CODE
, LE_NAME
, LE_ADDR1
, LE_ADDR2
, LE_ADDR3
, LE_TOWN_CITY
, LE_STAE_PROVINCE
, LE_POSTALCODE
, LE_COUNTRY
, CANCEL_DATE
, CHANGE_SUMMARY
, DOCUMENT_CREATION_METHOD
, ENCUMBRANCE_REQUIRED_FLAG
, STYLE_DISPLAY_NAME
FROM APPS.PO_HEADERS_XML;
APPS
AP_TERMS
FND_CURRENCIES_TL
FND_GLOBAL
- show dependent code
FND_LOOKUP_VALUES
FND_TERRITORIES_TL
ORG_FREIGHT_TL
PER_ALL_PEOPLE_F
PO_AGENTS
PO_COMMUNICATION_PVT
- show dependent code
PO_CORE_S
- show dependent code
PO_DOC_STYLE_LINES_TL
PO_HEADERS_ALL
PO_VENDORS
PO_VENDOR_CONTACTS
PO_VENDOR_SITES_ALL
APPS.PO_HEADERS_XML is not referenced by any database object
|
|
|
|