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

Object Details

Object Name:	PO_PURCHASE_HISTORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.PO_PURCHASE_HISTORY_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PO_HEADER_ID	NUMBER		Yes
PO_RELEASE_ID	NUMBER
CREATION_DATE	DATE			Standard who column - date when this row was created.
REVISED_DATE	DATE
VENDOR_ID	NUMBER
VENDOR_NAME	VARCHAR2	(240)
VENDOR_CONTACT_ID	NUMBER
VENDOR_CONTACT_NAME	VARCHAR2	(32)
PARENT_VENDOR_ID	NUMBER
PARENT_VENDOR_NAME	VARCHAR2	(240)
HOLD_FLAG	VARCHAR2	(1)
VENDOR_SITE_ID	NUMBER
VENDOR_SITE_CODE	VARCHAR2	(15)	Yes
WOMEN_OWNED_FLAG	VARCHAR2	(1)
SMALL_BUSINES	VARCHAR2	(1)
MINORITY_GROUP_LOOKUP_CODE	VARCHAR2	(25)
MINORITY_GROUP_LOOKUP_DSP	VARCHAR2	(80)
TYPE_LOOKUP_CODE	VARCHAR2	(25)
TYPE_NAME	VARCHAR2	(80)
DOCUMENT_NUM_FULL	VARCHAR2	(61)
DOCUMENT_NUM_SEGMENT1	VARCHAR2	(20)	Yes
DOCUMENT_NUM_RELEASE	NUMBER
AGENT_ID	NUMBER
AGENT_NAME	VARCHAR2	(240)
PAYMENT_TERMS_ID	NUMBER
PAYMENT_TERMS_NAME	VARCHAR2	(50)
SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)
FREIGHT_TERMS_LOOKUP_CODE	VARCHAR2	(25)
FOB_LOOKUP_CODE	VARCHAR2	(25)
CURRENCY_CODE	VARCHAR2	(15)
RATE_TYPE	VARCHAR2	(30)
RATE_DATE	DATE
RATE	NUMBER
AUTHORIZATION_STATUS_CODE	VARCHAR2	(25)
AUTHORIZATION_STATUS_DSP	VARCHAR2	(80)	Yes
PO_LINE_ID	NUMBER		Yes
LINE_TYPE_ID	NUMBER		Yes
LINE_TYPE	VARCHAR2	(25)	Yes
ITEM_ID	NUMBER
ITEM_REVISION	VARCHAR2	(3)
CATEGORY_ID	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)
VENDOR_PRODUCT_NUM	VARCHAR2	(25)
CONTRACT_NUM	VARCHAR2	(25)
FROM_HEADER_ID	NUMBER
FROM_HEADER_NUM	VARCHAR2	(20)
FROM_LINE_ID	NUMBER
FROM_LINE_NUM	NUMBER
SHIP_TO_LOCATION_ID	NUMBER
SHIP_TO_LOCATION_CODE	VARCHAR2	(60)
SHIP_TO_ORGANIZATION_ID	NUMBER
SHIP_TO_ORGANIZATION_CODE	VARCHAR2	(3)
SHIP_TO_ORGANIZATION_NAME	VARCHAR2	(240)	Yes
PROMISED_DATE	DATE
NEED_BY_DATE	DATE
QUANTITY_RECEIVED	NUMBER
QUANTITY_BILLED	NUMBER
QUANTITY_REJECTED	NUMBER
QUANTITY_ACCEPTED	NUMBER
LINE_LOCATION_ID	NUMBER		Yes
LINE_SHIP_CONCAT_NUM	VARCHAR2	(81)
ORDER_QUANTITY	NUMBER
CURRENCY_PRICE	NUMBER
FUNCTIONAL_PRICE	NUMBER
FUNCTIONAL_CURRENCY	VARCHAR2	(15)	Yes
EXTENDED_CURRENCY_PRICE	NUMBER
EXTENDED_FUNCTIONAL_PRICE	NUMBER
RATE_TYPE_NAME	VARCHAR2	(30)
OUTSIDE_OPERATION_FLAG	VARCHAR2	(1)
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes
ORDER_TYPE_LOOKUP_DSP	VARCHAR2	(80)	Yes
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)
SECONDARY_QUANTITY_RECEIVED	NUMBER
SECONDARY_QUANTITY_REJECTED	NUMBER
SECONDARY_QUANTITY_ACCEPTED	NUMBER
SECONDARY_ORDER_QUANTITY	NUMBER
PREFERRED_GRADE	VARCHAR2	(150)
CONTRACT_ID	NUMBER			Contract PA reference on the PO Line. Applicable to Standard PO only.
JOB_ID	NUMBER			Job reference
AMOUNT	NUMBER			Amount
CONTRACTOR_FIRST_NAME	VARCHAR2	(240)		Contractor First name
CONTRACTOR_LAST_NAME	VARCHAR2	(240)		Contractor Last name
START_DATE	DATE			Assignment start date
EXPIRATION_DATE	DATE			Expiration date
PURCHASE_BASIS	VARCHAR2	(30)	Yes	Purchase basis
FROM_GLOBAL_FLAG	VARCHAR2	(1)		The global agreement flag of the source document.
FROM_ORG_ID	NUMBER			The operating unit identifier of the source document.
NEGOTIATED_BY_PREPARER_FLAG	VARCHAR2	(1)
MATCHING_BASIS	VARCHAR2	(30)	Yes	Matching basis of the PO line. References PO_LINE_TYPES.MATCHING_BASIS.
MANUAL_PRICE_CHANGE_FLAG	VARCHAR2	(1)		Only for Standard PO lines referencing a Global Agreeement, Contract, or Quotation, and for Blanket Release shipments: Y if the user has manually entered a price overriding the source document price, N or null otherwise.
FROM_TYPE_LOOKUP_CODE	VARCHAR2	(25)		The type of the source document.
SECONDARY_QUANTITY_SHIPPED	NUMBER
ORG_ID	NUMBER			Organization identifier

Query Text

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


SELECT PO_HEADER_ID
,      PO_RELEASE_ID
,      CREATION_DATE
,      REVISED_DATE
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_CONTACT_ID
,      VENDOR_CONTACT_NAME
,      PARENT_VENDOR_ID
,      PARENT_VENDOR_NAME
,      HOLD_FLAG
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      WOMEN_OWNED_FLAG
,      SMALL_BUSINES
,      MINORITY_GROUP_LOOKUP_CODE
,      MINORITY_GROUP_LOOKUP_DSP
,      TYPE_LOOKUP_CODE
,      TYPE_NAME
,      DOCUMENT_NUM_FULL
,      DOCUMENT_NUM_SEGMENT1
,      DOCUMENT_NUM_RELEASE
,      AGENT_ID
,      AGENT_NAME
,      PAYMENT_TERMS_ID
,      PAYMENT_TERMS_NAME
,      SHIP_VIA_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      FOB_LOOKUP_CODE
,      CURRENCY_CODE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      AUTHORIZATION_STATUS_CODE
,      AUTHORIZATION_STATUS_DSP
,      PO_LINE_ID
,      LINE_TYPE_ID
,      LINE_TYPE
,      ITEM_ID
,      ITEM_REVISION
,      CATEGORY_ID
,      ITEM_DESCRIPTION
,      UNIT_MEAS_LOOKUP_CODE
,      VENDOR_PRODUCT_NUM
,      CONTRACT_NUM
,      FROM_HEADER_ID
,      FROM_HEADER_NUM
,      FROM_LINE_ID
,      FROM_LINE_NUM
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION_CODE
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      SHIP_TO_ORGANIZATION_NAME
,      PROMISED_DATE
,      NEED_BY_DATE
,      QUANTITY_RECEIVED
,      QUANTITY_BILLED
,      QUANTITY_REJECTED
,      QUANTITY_ACCEPTED
,      LINE_LOCATION_ID
,      LINE_SHIP_CONCAT_NUM
,      ORDER_QUANTITY
,      CURRENCY_PRICE
,      FUNCTIONAL_PRICE
,      FUNCTIONAL_CURRENCY
,      EXTENDED_CURRENCY_PRICE
,      EXTENDED_FUNCTIONAL_PRICE
,      RATE_TYPE_NAME
,      OUTSIDE_OPERATION_FLAG
,      ORDER_TYPE_LOOKUP_CODE
,      ORDER_TYPE_LOOKUP_DSP
,      SECONDARY_UNIT_OF_MEASURE
,      SECONDARY_QUANTITY_RECEIVED
,      SECONDARY_QUANTITY_REJECTED
,      SECONDARY_QUANTITY_ACCEPTED
,      SECONDARY_ORDER_QUANTITY
,      PREFERRED_GRADE
,      CONTRACT_ID
,      JOB_ID
,      AMOUNT
,      CONTRACTOR_FIRST_NAME
,      CONTRACTOR_LAST_NAME
,      START_DATE
,      EXPIRATION_DATE
,      PURCHASE_BASIS
,      FROM_GLOBAL_FLAG
,      FROM_ORG_ID
,      NEGOTIATED_BY_PREPARER_FLAG
,      MATCHING_BASIS
,      MANUAL_PRICE_CHANGE_FLAG
,      FROM_TYPE_LOOKUP_CODE
,      SECONDARY_QUANTITY_SHIPPED
,      ORG_ID
FROM APPS.PO_PURCHASE_HISTORY_V;

Dependencies

[top of page]

APPS.PO_PURCHASE_HISTORY_V references the following:

APPS: AP_TERMS; FINANCIALS_SYSTEM_PARAMS_ALL; FND_GLOBAL - show dependent code; GL_DAILY_CONVERSION_TYPES; GL_SETS_OF_BOOKS; HR_ALL_ORGANIZATION_UNITS_TL; HR_LOCATIONS_ALL_TL; MTL_PARAMETERS; PER_ALL_PEOPLE_F; PO_DOCUMENT_TYPES_ALL_B; PO_DOCUMENT_TYPES_ALL_TL; PO_HEADERS; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES; PO_LOOKUP_CODES; PO_RELEASES_ALL; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL

APPS.PO_PURCHASE_HISTORY_V is not referenced by any database object