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: ViewPO.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)

WOMEN_OWNED_FLAG VARCHAR2 (1)

SMALL_BUSINES VARCHAR2 (1)

MINORITY_GROUP_LOOKUP_CODE VARCHAR2 (30)

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


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:

SchemaAPPS
SynonymAP_TERMS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymGL_DAILY_CONVERSION_TYPES
ViewGL_SETS_OF_BOOKS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_LOCATIONS_ALL_TL
SynonymMTL_PARAMETERS
SynonymPER_ALL_PEOPLE_F
SynonymPO_DOCUMENT_TYPES_ALL_B
SynonymPO_DOCUMENT_TYPES_ALL_TL
SynonymPO_HEADERS
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_LINE_TYPES
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.PO_PURCHASE_HISTORY_V is not referenced by any database object