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_NEGOTIATED_SOURCES_V

Object Details

Object Name:	PO_NEGOTIATED_SOURCES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.PO_NEGOTIATED_SOURCES_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	Comments
PO_HEADER_ID	NUMBER
VENDOR_ID	NUMBER
VENDOR_NAME	VARCHAR2	(360)
VENDOR_CONTACT_ID	NUMBER
VENDOR_CONTACT_NAME	VARCHAR2	(77)
PARENT_VENDOR_ID	NUMBER
PARENT_VENDOR_NAME	VARCHAR2	(360)
HOLD_FLAG	VARCHAR2	(1)
VENDOR_SITE_ID	NUMBER
VENDOR_SITE_CODE	VARCHAR2	(15)
WOMEN_OWNED_FLAG	VARCHAR2	(1)
SMALL_BUSINESS_FLAG	VARCHAR2	(1)
MINORITY_GROUP_LOOKUP_CODE	VARCHAR2	(30)
MINORITY_GROUP_LOOKUP_DSP	VARCHAR2	(80)
TYPE_LOOKUP_CODE	VARCHAR2	(25)
TYPE_NAME	VARCHAR2	(80)
DOCUMENT_STATUS_CODE	VARCHAR2	(25)
DOCUMENT_STATUS_DSP	VARCHAR2	(80)
DOCUMENT_NUM	VARCHAR2	(20)
AGENT_ID	NUMBER	(9)
AGENT_NAME	VARCHAR2	(240)
HEADER_PAYMENT_TERMS_ID	NUMBER
HEADER_PAYMENT_TERMS_NAME	VARCHAR2	(50)
HEADER_SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)
HEADER_FREIGHT_TERMS_CODE	VARCHAR2	(25)
HEADER_FOB_LOOKUP_CODE	VARCHAR2	(25)
CURRENCY_CODE	VARCHAR2	(15)
VENDOR_QUOTE_NUM	VARCHAR2	(25)
QUOTE_APPROVAL_REQUIRED_FLAG	VARCHAR2	(1)
ASSOCIATED_RFQ_ID	NUMBER
ASSOCIATED_RFQ_NUM	VARCHAR2	(20)
EFFECTIVE_FROM	DATE
EFFECTIVE_TO	DATE
AMOUNT_AGREED	NUMBER
AMOUNT_LIMIT	NUMBER
HEADER_MIN_RELEASE_AMOUNT	NUMBER
PO_LINE_ID	NUMBER
LINE_NUM	NUMBER
LINE_TYPE_ID	NUMBER
LINE_TYPE	VARCHAR2	(25)
LINE_SHIP_CONCAT_NUM	VARCHAR2	(81)
ITEM_ID	NUMBER
ITEM_REVISION	VARCHAR2	(3)
CATEGORY_ID	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
LINE_UOM	VARCHAR2	(25)
LINE_QUANTITY	NUMBER
CURRENCY_LINE_PRICE	NUMBER
VENDOR_PRODUCT_NUM	VARCHAR2	(25)
QUANTITY_AGREED	NUMBER
QUOTE_MIN_ORDER_QUANTITY	NUMBER
QUOTE_MAX_ORDER_QUANTITY	NUMBER
LINE_LOCATION_ID	NUMBER
SHIPMENT_QUANTITY	NUMBER
CURRENCY_SHIPMENT_PRICE	NUMBER
SHIPMENT_UOM	VARCHAR2	(25)
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)
SHIPMENT_SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)
SHIPMENT_FOB_LOOKUP_CODE	VARCHAR2	(25)
SHIPMENT_FREIGHT_TERMS_CODE	VARCHAR2	(25)
SHIPMENT_PAYMENT_TERMS_ID	NUMBER
SHIPMENT_PAYMENT_TERMS_NAME	VARCHAR2	(50)
SHIPMENT_EFFECTIVE_FROM	DATE
SHIPMENT_EFFECTIVE_TO	DATE
QUOTE_LEAD_TIME	NUMBER
QUOTE_LEAD_TIME_UOM	VARCHAR2	(25)
FUNCTIONAL_CURRENCY	VARCHAR2	(15)
OUTSIDE_OPERATION_FLAG	VARCHAR2	(1)
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)
ORDER_TYPE_LOOKUP_DSP	VARCHAR2	(80)
SECONDARY_LINE_UOM	VARCHAR2	(25)
SECONDARY_LINE_QUANTITY	NUMBER
SECONDARY_SHIPMENT_UOM	VARCHAR2	(25)
SECONDARY_SHIPMENT_QUANTITY	NUMBER
PREFERRED_GRADE	VARCHAR2	(150)
GLOBAL_AGREEMENT_FLAG	VARCHAR2	(1)	global agreement flag to indicate if the agreement is global
OWNING_ORG_ID	NUMBER		owning organization of the global agreement
AMOUNT	NUMBER		Amount
JOB_ID	NUMBER		HR Job reference
PURCHASE_BASIS	VARCHAR2	(30)	Purchase basis of the line
GA_REQUESTING_ORG_ID	NUMBER		The Requesting Org of the current org assignment for this Global Agreement
GA_PURCHASING_ORG_ID	NUMBER		The Purchasing Org of the current org assignment for this Global Agreement
NEGOTIATED_BY_PREPARER_FLAG	VARCHAR2	(1)
MATCHING_BASIS	VARCHAR2	(30)	Matching basis of the PO line. References PO_LINE_TYPES.MATCHING_BASIS.
ORG_ID	NUMBER		Organization identifier

Query Text

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


SELECT PO_HEADER_ID
,      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_BUSINESS_FLAG
,      MINORITY_GROUP_LOOKUP_CODE
,      MINORITY_GROUP_LOOKUP_DSP
,      TYPE_LOOKUP_CODE
,      TYPE_NAME
,      DOCUMENT_STATUS_CODE
,      DOCUMENT_STATUS_DSP
,      DOCUMENT_NUM
,      AGENT_ID
,      AGENT_NAME
,      HEADER_PAYMENT_TERMS_ID
,      HEADER_PAYMENT_TERMS_NAME
,      HEADER_SHIP_VIA_LOOKUP_CODE
,      HEADER_FREIGHT_TERMS_CODE
,      HEADER_FOB_LOOKUP_CODE
,      CURRENCY_CODE
,      VENDOR_QUOTE_NUM
,      QUOTE_APPROVAL_REQUIRED_FLAG
,      ASSOCIATED_RFQ_ID
,      ASSOCIATED_RFQ_NUM
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      AMOUNT_AGREED
,      AMOUNT_LIMIT
,      HEADER_MIN_RELEASE_AMOUNT
,      PO_LINE_ID
,      LINE_NUM
,      LINE_TYPE_ID
,      LINE_TYPE
,      LINE_SHIP_CONCAT_NUM
,      ITEM_ID
,      ITEM_REVISION
,      CATEGORY_ID
,      ITEM_DESCRIPTION
,      LINE_UOM
,      LINE_QUANTITY
,      CURRENCY_LINE_PRICE
,      VENDOR_PRODUCT_NUM
,      QUANTITY_AGREED
,      QUOTE_MIN_ORDER_QUANTITY
,      QUOTE_MAX_ORDER_QUANTITY
,      LINE_LOCATION_ID
,      SHIPMENT_QUANTITY
,      CURRENCY_SHIPMENT_PRICE
,      SHIPMENT_UOM
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION_CODE
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      SHIP_TO_ORGANIZATION_NAME
,      SHIPMENT_SHIP_VIA_LOOKUP_CODE
,      SHIPMENT_FOB_LOOKUP_CODE
,      SHIPMENT_FREIGHT_TERMS_CODE
,      SHIPMENT_PAYMENT_TERMS_ID
,      SHIPMENT_PAYMENT_TERMS_NAME
,      SHIPMENT_EFFECTIVE_FROM
,      SHIPMENT_EFFECTIVE_TO
,      QUOTE_LEAD_TIME
,      QUOTE_LEAD_TIME_UOM
,      FUNCTIONAL_CURRENCY
,      OUTSIDE_OPERATION_FLAG
,      ORDER_TYPE_LOOKUP_CODE
,      ORDER_TYPE_LOOKUP_DSP
,      SECONDARY_LINE_UOM
,      SECONDARY_LINE_QUANTITY
,      SECONDARY_SHIPMENT_UOM
,      SECONDARY_SHIPMENT_QUANTITY
,      PREFERRED_GRADE
,      GLOBAL_AGREEMENT_FLAG
,      OWNING_ORG_ID
,      AMOUNT
,      JOB_ID
,      PURCHASE_BASIS
,      GA_REQUESTING_ORG_ID
,      GA_PURCHASING_ORG_ID
,      NEGOTIATED_BY_PREPARER_FLAG
,      MATCHING_BASIS
,      ORG_ID
FROM APPS.PO_NEGOTIATED_SOURCES_V;

Dependencies

[top of page]

APPS.PO_NEGOTIATED_SOURCES_V references the following:

APPS: AP_SUPPLIERS; AP_SUPPLIER_CONTACTS; AP_SUPPLIER_SITES_ALL; AP_TERMS; FINANCIALS_SYSTEM_PARAMETERS; FND_GLOBAL - show dependent code; GL_SETS_OF_BOOKS; HR_ALL_ORGANIZATION_UNITS_TL; HR_LOCATIONS_ALL_TL; HZ_PARTIES; MTL_PARAMETERS; PER_ALL_PEOPLE_F; PO_DOCUMENT_TYPES_ALL_B; PO_DOCUMENT_TYPES_ALL_TL; PO_GA_ORG_ASSIGNMENTS; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES; PO_LOOKUP_CODES; PO_SYSTEM_PARAMETERS

APPS.PO_NEGOTIATED_SOURCES_V is not referenced by any database object