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


VIEW: APPS.POS_PO_HEADERS_ARCHIVE_V

Object Details
Object Name: POS_PO_HEADERS_ARCHIVE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_PO_HEADERS_ARCHIVE_V
Subobject Name:
Status: VALID

View Type

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


This View Displays Revisions for Purchase orders from PO_HEADERS_ARCHIVE_ALL


[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_RELEASE_FLAG CHAR (1)
Indicated if document is a release
ACCEPTANCE_DUE_DATE DATE

Acceptance due date of the Document
APPROVED_DATE DATE

Approval date of the document
AUTHORIZATION_STATUS VARCHAR2 (25)
Authorization status of the document
CLOSED_DATE DATE

Closure date of the document
COMMENTS VARCHAR2 (240)
Descriptive comments for the document
NOTE_TO_RECEIVER VARCHAR2 (480)
Note to the receiver of the purchase order
NOT_TO_VENDOR VARCHAR2 (480)
Note to the supplier of the purchase order
PRINT_COUNT NUMBER

Number of times the document was printed
PRINTED_DATE DATE

Date the document was printed
RATE NUMBER

Currency conversion rate
RATE_DATE DATE

Currency conversion date
RATE_TYPE VARCHAR2 (30)
Currency conversion rate type
REVISED_DATE DATE

Date of revision on the document
REVISION_NUM NUMBER

revision number of the document
AGENT_ID NUMBER (9)
Employee id
BILL_TO_LOCATION_ID NUMBER

Unique identifier of the bill-to location for the document
FROM_HEADER_ID NUMBER

Unique identifier of the RFQ used to autocreate a quotation
PO_HEADER_ID NUMBER

Document unique identifier
SHIP_TO_LOCATION_ID NUMBER

Unique identifier of the ship-to location for the document
TERMS_ID NUMBER

Payment terms unique identifier
VENDOR_CONTACT_ID NUMBER

Supplier contact unique identifier
VENDOR_ID NUMBER

Supplier unique identifier
VENDOR_SITE_ID NUMBER

Supplier Site unique identifier
CLOSED_CODE VARCHAR2 (25)
Describes the closure status of the document
CURRENCY_CODE VARCHAR2 (15)
Currency code
FIRM_STATUS_LOOKUP_CODE VARCHAR2 (30)
Describes the closure status of the document
FOB_LOOKUP_CODE VARCHAR2 (25)
Type of free-on-board terms for the document
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)
Type of freight terms for the document
SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
Type of carrier to be used
TYPE_LOOKUP_CODE VARCHAR2 (25)
Type of the document
ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether acceptance from the supplier is required or not
APPROVED_FLAG VARCHAR2 (1)
Indicates whether the purchase order is approved or not
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
ENABLED_FLAG VARCHAR2 (1)
Key Flexfield enabled flag
FROZEN_FLAG VARCHAR2 (1)
Indicates whether the document is frozen or not
SUMMARY_FLAG VARCHAR2 (1)
Key Flexfield summary flag
USER_HOLD_FLAG VARCHAR2 (1)
Indicates whether the purchase order is on hold or not
CREATED_BY NUMBER

Standard Who Column
ORDER_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
PO_NUM VARCHAR2 (20)
Document Number
PONUM_RELNUM VARCHAR2 (61)
Document Number and release Number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Desciptive Flex Field
ATTRIBUTE1 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE2 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE3 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE4 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE5 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE6 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE7 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE8 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE9 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE10 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE11 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE12 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE13 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE14 VARCHAR2 (150)
Desciptive Flex Field
ATTRIBUTE15 VARCHAR2 (150)
Desciptive Flex Field
DOC_TYPE_NAME VARCHAR2 (4000)
Document Type Name
AGENT_NAME VARCHAR2 (4000)
Employee name
VENDOR_NAME VARCHAR2 (240)
Supplier Name
VENDOR_SITE_CODE VARCHAR2 (15)
Supplier Site Code
ADDRESS_LINE1 VARCHAR2 (240)
Address Line
ADDRESS_LINE2 VARCHAR2 (240)
Address Line
ADDRESS_LINE3 VARCHAR2 (240)
Address Line
CITY VARCHAR2 (25)
City
STATE VARCHAR2 (150)
State
ZIP VARCHAR2 (20)
zip code
COUNTRY VARCHAR2 (25)
country
PHONE VARCHAR2 (28)
Phone No
FAX VARCHAR2 (28)
Fax Number
VENDOR_CONTACT VARCHAR2 (32)
Supplier Contact
TERMS_NAME VARCHAR2 (50)
Payment Terms Name
SHIP_TO_LOCATION VARCHAR2 (60)
Ship to location
BILL_TO_LOCATION VARCHAR2 (60)
Bill to location
RATE_CONVERSION_TYPE VARCHAR2 (30)
Currency Code conversion type
AUTHORIZATION_STATUS_DSP VARCHAR2 (80)
Displayed Field
FOB_DSP VARCHAR2 (80)
Displayed Field
FREIGHT_TERMS_DSP VARCHAR2 (80)
Displayed Field
CLOSED_CODE_DSP VARCHAR2 (80)
Displayed Field
CANCELLED_BY_NAME VARCHAR2 (4000)
Name of employee who cancelled the Document
RELEASE_NUM NUMBER

Release Number
RELEASE_TYPE VARCHAR2 (25)
Release Type
PO_RELEASE_ID NUMBER

Release unique identifier
AMOUNT VARCHAR2 (4000)
Total Amount
SUPPLIER_URL VARCHAR2 (150)
Supplier Info URL
ORG_ID NUMBER

Organization Unique identifier
ORG_NAME VARCHAR2 (240)
Organization Name
Query Text

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


SELECT PO_RELEASE_FLAG
,      ACCEPTANCE_DUE_DATE
,      APPROVED_DATE
,      AUTHORIZATION_STATUS
,      CLOSED_DATE
,      COMMENTS
,      NOTE_TO_RECEIVER
,      NOT_TO_VENDOR
,      PRINT_COUNT
,      PRINTED_DATE
,      RATE
,      RATE_DATE
,      RATE_TYPE
,      REVISED_DATE
,      REVISION_NUM
,      AGENT_ID
,      BILL_TO_LOCATION_ID
,      FROM_HEADER_ID
,      PO_HEADER_ID
,      SHIP_TO_LOCATION_ID
,      TERMS_ID
,      VENDOR_CONTACT_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CLOSED_CODE
,      CURRENCY_CODE
,      FIRM_STATUS_LOOKUP_CODE
,      FOB_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      SHIP_VIA_LOOKUP_CODE
,      TYPE_LOOKUP_CODE
,      ACCEPTANCE_REQUIRED_FLAG
,      APPROVED_FLAG
,      CANCEL_FLAG
,      CONFIRMING_ORDER_FLAG
,      ENABLED_FLAG
,      FROZEN_FLAG
,      SUMMARY_FLAG
,      USER_HOLD_FLAG
,      CREATED_BY
,      ORDER_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PO_NUM
,      PONUM_RELNUM
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DOC_TYPE_NAME
,      AGENT_NAME
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY
,      STATE
,      ZIP
,      COUNTRY
,      PHONE
,      FAX
,      VENDOR_CONTACT
,      TERMS_NAME
,      SHIP_TO_LOCATION
,      BILL_TO_LOCATION
,      RATE_CONVERSION_TYPE
,      AUTHORIZATION_STATUS_DSP
,      FOB_DSP
,      FREIGHT_TERMS_DSP
,      CLOSED_CODE_DSP
,      CANCELLED_BY_NAME
,      RELEASE_NUM
,      RELEASE_TYPE
,      PO_RELEASE_ID
,      AMOUNT
,      SUPPLIER_URL
,      ORG_ID
,      ORG_NAME
FROM APPS.POS_PO_HEADERS_ARCHIVE_V;

Dependencies

[top of page]

APPS.POS_PO_HEADERS_ARCHIVE_V references the following:

SchemaAPPS
SynonymAP_TERMS
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_MESSAGE - show dependent code
SynonymGL_DAILY_CONVERSION_TYPES
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_LOCATIONS_ALL_TL
PL/SQL PackagePOS_GET - show dependent code
PL/SQL PackagePOS_TOTALS_PO_SV - show dependent code
SynonymPO_HEADERS_ARCHIVE_ALL
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ARCHIVE_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.POS_PO_HEADERS_ARCHIVE_V is not referenced by any database object