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]

TABLE: PO.POA_BIS_SUPPLIER_PERFORMANCE

Object Details

Object Name:	POA_BIS_SUPPLIER_PERFORMANCE
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.POA_BIS_SUPPLIER_PERFORMANCE
Subobject Name:
Status:	VALID

Elements of this table are used to provide summary information to compare suppliers for an item. Supplier comparisons are based on price, quality, delivery, amount, and quantity by item.
Data within this table is used for Purchasing Intelligence, for the Supplier Performance and Supplier Consolidation reports.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POA_BIS_SUPPLIER_PERF_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	PO_SHIPMENT_ID
POA_BIS_SUPPLIER_PERF_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ITEM_ID SUPPLIER_ID
POA_BIS_SUPPLIER_PERF_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SUPPLIER_ID
POA_BIS_SUPPLIER_PERF_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ITEM_ID SHIP_TO_ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PO_SHIPMENT_ID	NUMBER		Yes	Document shipment schedule unique identifier
SHIP_TO_LOCATION_ID	NUMBER		Yes	Ship-to location unique identifier
SHIP_TO_ORGANIZATION_ID	NUMBER		Yes	Ship-to organization unique identifier
ORG_ID	NUMBER			Organization identifier
ITEM_ID	NUMBER			Item unique identifier
CATEGORY_ID	NUMBER			Item category unique identifier
SUPPLIER_ID	NUMBER		Yes	Supplier unique identifier
SUPPLIER_SITE_ID	NUMBER			Supplier site unique identifier
BUYER_ID	NUMBER		Yes	Buyer unique identifier
DATE_DIMENSION	DATE			Transaction date for supplier comparison
QUANTITY_PURCHASED	NUMBER			Quantity purchased expressed in the primary unit of measure
PURCHASE_PRICE	NUMBER			Purchase price
PRIMARY_UOM	VARCHAR2	(25)		Primary unit of measure code
CURRENCY_CODE	VARCHAR2	(15)		Currency code
RATE_TYPE	VARCHAR2	(30)		Currency conversion rate type
RATE_DATE	DATE			Currency conversion date
RATE	NUMBER			Currency conversion rate
QUANTITY_ORDERED	NUMBER			Quantity ordered
QUANTITY_RECEIVED	NUMBER			Quantity received
QUANTITY_REJECTED	NUMBER			Quantity rejected
AMOUNT	NUMBER			Amount purchased
NUMBER_OF_RECEIPTS	NUMBER			Number of receipts for the shipment schedule
QUANTITY_RECEIVED_LATE	NUMBER			Quantity received late
QUANTITY_RECEIVED_EARLY	NUMBER			Quantity received early
QUANTITY_PAST_DUE	NUMBER			Quantity past due
FIRST_RECEIPT_DATE	DATE			First receipt date of the shipment
SHIPMENT_EXPECTED_DATE	DATE			Shipment expected date
MONTH_BUCKET	DATE			Month of the date dimension
QUARTER_BUCKET	DATE			Quarter of the date dimension
YEAR_BUCKET	DATE			Year of the date dimension
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	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).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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).

Query Text

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


SELECT PO_SHIPMENT_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_ORGANIZATION_ID
,      ORG_ID
,      ITEM_ID
,      CATEGORY_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      BUYER_ID
,      DATE_DIMENSION
,      QUANTITY_PURCHASED
,      PURCHASE_PRICE
,      PRIMARY_UOM
,      CURRENCY_CODE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      QUANTITY_ORDERED
,      QUANTITY_RECEIVED
,      QUANTITY_REJECTED
,      AMOUNT
,      NUMBER_OF_RECEIPTS
,      QUANTITY_RECEIVED_LATE
,      QUANTITY_RECEIVED_EARLY
,      QUANTITY_PAST_DUE
,      FIRST_RECEIPT_DATE
,      SHIPMENT_EXPECTED_DATE
,      MONTH_BUCKET
,      QUARTER_BUCKET
,      YEAR_BUCKET
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM PO.POA_BIS_SUPPLIER_PERFORMANCE;

Dependencies

[top of page]

PO.POA_BIS_SUPPLIER_PERFORMANCE does not reference any database object

PO.POA_BIS_SUPPLIER_PERFORMANCE is referenced by following:

APPS: POA_BIS_SUPPLIER_PERFORMANCE