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

Object Details

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

View Type

A Business Intelligence System view

EDW Supplier Performance Fact Collection View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SEQ_ID	NUMBER			Sequence number
VIEW_ID	NUMBER			view ID
SUP_PERF_PK	VARCHAR2	(71)		Supplier Performance Primary Key
SUPPLIER_ITEM_FK	VARCHAR2	(282)		Supplier Item number FK
PURCH_CLASS_FK	VARCHAR2	(4000)		Purchase Classification FK
INVOICE_DATE_FK	VARCHAR2	(76)		Invoice Date FK
EDW_BASE_UOM_FK	VARCHAR2	(4000)		Base UOM FK
EDW_UOM_FK	VARCHAR2	(4000)		UOM FK
INSTANCE_FK	VARCHAR2	(30)		Source database instance FK
SUPPLIER_SITE_FK	VARCHAR2	(4000)		Supplier SIte FK
SHIP_TO_ORG_FK	VARCHAR2	(4000)		Ship-to Org FK
SHIP_LOCATION_FK	VARCHAR2	(4000)		Ship-to Location FK
SUP_SITE_GEOG_FK	VARCHAR2	(223)		Supplier Site Geography FK
ITEM_FK	VARCHAR2	(4000)		Item FK
BUYER_FK	VARCHAR2	(4000)		Buyer FK
DATE_DIM_FK	VARCHAR2	(76)		Date Dimension FK
PROMISED_DATE_FK	VARCHAR2	(76)		Promised date FK
NEED_BY_DATE_FK	VARCHAR2	(76)		Needby date FK
CREATION_DATE_FK	VARCHAR2	(76)		Creation date FK
FIRST_REC_DATE_FK	VARCHAR2	(76)		First Receipt Date FK
LST_ACCPT_DATE_FK	VARCHAR2	(76)		Last Accept Date FK
APPROVAL_DATE_FK	VARCHAR2	(76)		Approval Date FK
AP_TERMS_FK	VARCHAR2	(74)		AP Terms FK
TXN_CUR_CODE_FK	VARCHAR2	(15)		Transactional currency code FK
PRICE_TYPE_FK	VARCHAR2	(39)		Price Type FK
CLOSED_CODE_FK	VARCHAR2	(48)		Closed Code FK
PO_LINE_TYPE_FK	VARCHAR2	(25)	Yes	PO Line Type FK
IPV_T	NUMBER			Invoice Price Variance (transactional)
IPV_G	NUMBER			Invoice price variance (global currency)
PRICE_T	VARCHAR2	(40)		Price (transactional)
PRICE_G	VARCHAR2	(40)		Price (global currency)
MARKET_PRICE_T	VARCHAR2	(40)		market price (transactional)
MARKET_PRICE_G	VARCHAR2	(40)		market price (warehouse/global currency)
LIST_PRICE_T	VARCHAR2	(40)		List Price Per unit (transactional)
LIST_PRICE_G	VARCHAR2	(40)		List Price per unit (warehouse currency)
TARGET_PRICE_T	NUMBER			Target Price (transactional)
TARGET_PRICE_G	VARCHAR2	(40)		Target Price (warehouse currency)
AMT_PURCHASED_G	VARCHAR2	(40)		Amount Purchased (transactional)
AMT_PURCHASED_T	VARCHAR2	(40)		amount purchased (warehouse)
QTY_ORDERED_B	VARCHAR2	(40)		Quantity ordered (functional)
QTY_CANCELLED_B	NUMBER			Quantity cancelled (functional)
QTY_SHIPPED_B	NUMBER			Quantity shipped (functional)
QTY_RECEIVED_B	NUMBER			Quantity received (functional)
QTY_REJECTED_B	NUMBER			Quantity rejected (functional)
QTY_ACCEPTED_B	NUMBER			Quantity accepted (functional)
QTY_DELIVERED_B	NUMBER			Quantity delivered (functional)
NUM_RECEIPT_LINES	NUMBER			number of receipt lines
NUM_EARLY_RECEIPT	NUMBER			number of early receipts
NUM_LATE_RECEIPT	NUMBER			Number of late receipts
NUM_ONTIME_BEFDUE	NUMBER			Number of on-time receipts before due
NUM_ONTIME_AFTDUE	NUMBER			number of on-time receipts after due
NUM_ONTIME_ONDUE	NUMBER			number of on-time receipts on due
NUM_SUBS_RECEIPT	NUMBER			number of substitute receipts
QTY_EARLY_RECEIPT_B	NUMBER			Quantity of early receipts (functional)
QTY_LATE_RECEIPT_B	NUMBER			quantity of late receipts (functional)
QTY_PAST_DUE_B	NUMBER			Quantity of past due receipts (functional)
QTY_ONTIME_BEFDUE_B	NUMBER			Quantity of ontime receipts before due (functional)
QTY_ONTIME_AFTDUE_B	NUMBER			Quantity of ontime receipts after due (functional)
QTY_ONTIME_ONDUE_B	NUMBER			number of ontime receipts on due (functional)
QTY_SUBS_RECEIPT_B	NUMBER			number of substitute receipts (functional)
DAYS_EARLY_REC	NUMBER			Days early receipts allowed
DAYS_LATE_REC	NUMBER			Days late receipts allowed
QTY_RECEIVED_TOL	NUMBER			Quantity received tolarance
NUM_DAYS_TO_INVOICE	VARCHAR2	(40)		Days to Invoice
RCV_CLOSE_TOL	NUMBER			Receive Close Tolerance
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
PO_NUMBER	VARCHAR2	(20)	Yes	PO Number
CONTRACT_NUM	VARCHAR2	(20)		Contract Number
RELEASE_NUM	NUMBER			Release Number
OPERATION_CODE	VARCHAR2	(0)		Operation Code
DUNS_FK	VARCHAR2	(0)		DUNS number FK
UNSPSC_FK	VARCHAR2	(0)		UNSPSC number FK
SIC_CODE_FK	VARCHAR2	(0)		SIC Code FK
COLLECTION_STATUS	VARCHAR2	(18)		Collection status
_DF:PO_HDR:_EDW	CHAR	(21)		flexfield HDR
_DF:PO_LINES:_EDW	CHAR	(19)		flexfield Line
_DF:PO_PLL:_EDW	CHAR	(28)		flexfield Shipment

Query Text

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


SELECT SEQ_ID
,      VIEW_ID
,      SUP_PERF_PK
,      SUPPLIER_ITEM_FK
,      PURCH_CLASS_FK
,      INVOICE_DATE_FK
,      EDW_BASE_UOM_FK
,      EDW_UOM_FK
,      INSTANCE_FK
,      SUPPLIER_SITE_FK
,      SHIP_TO_ORG_FK
,      SHIP_LOCATION_FK
,      SUP_SITE_GEOG_FK
,      ITEM_FK
,      BUYER_FK
,      DATE_DIM_FK
,      PROMISED_DATE_FK
,      NEED_BY_DATE_FK
,      CREATION_DATE_FK
,      FIRST_REC_DATE_FK
,      LST_ACCPT_DATE_FK
,      APPROVAL_DATE_FK
,      AP_TERMS_FK
,      TXN_CUR_CODE_FK
,      PRICE_TYPE_FK
,      CLOSED_CODE_FK
,      PO_LINE_TYPE_FK
,      IPV_T
,      IPV_G
,      PRICE_T
,      PRICE_G
,      MARKET_PRICE_T
,      MARKET_PRICE_G
,      LIST_PRICE_T
,      LIST_PRICE_G
,      TARGET_PRICE_T
,      TARGET_PRICE_G
,      AMT_PURCHASED_G
,      AMT_PURCHASED_T
,      QTY_ORDERED_B
,      QTY_CANCELLED_B
,      QTY_SHIPPED_B
,      QTY_RECEIVED_B
,      QTY_REJECTED_B
,      QTY_ACCEPTED_B
,      QTY_DELIVERED_B
,      NUM_RECEIPT_LINES
,      NUM_EARLY_RECEIPT
,      NUM_LATE_RECEIPT
,      NUM_ONTIME_BEFDUE
,      NUM_ONTIME_AFTDUE
,      NUM_ONTIME_ONDUE
,      NUM_SUBS_RECEIPT
,      QTY_EARLY_RECEIPT_B
,      QTY_LATE_RECEIPT_B
,      QTY_PAST_DUE_B
,      QTY_ONTIME_BEFDUE_B
,      QTY_ONTIME_AFTDUE_B
,      QTY_ONTIME_ONDUE_B
,      QTY_SUBS_RECEIPT_B
,      DAYS_EARLY_REC
,      DAYS_LATE_REC
,      QTY_RECEIVED_TOL
,      NUM_DAYS_TO_INVOICE
,      RCV_CLOSE_TOL
,      LAST_UPDATE_DATE
,      PO_NUMBER
,      CONTRACT_NUM
,      RELEASE_NUM
,      OPERATION_CODE
,      DUNS_FK
,      UNSPSC_FK
,      SIC_CODE_FK
,      COLLECTION_STATUS
,      _DF:PO_HDR:_EDW
,      _DF:PO_LINES:_EDW
,      _DF:PO_PLL:_EDW
FROM APPS.POABV_EDW_SUPPLIER_PERFORM_FCV;

Dependencies

[top of page]

APPS.POABV_EDW_SUPPLIER_PERFORM_FCV references the following:

APPS: EDW_CURRENCY - show dependent code; EDW_GEOGRAPHY_PKG - show dependent code; EDW_HR_PERSON_PKG - show dependent code; EDW_ITEMS_PKG - show dependent code; EDW_LOCAL_INSTANCE; EDW_LOOKUP_PKG - show dependent code; EDW_ORGANIZATION_PKG - show dependent code; EDW_TRD_PARTNER_PKG - show dependent code; EDW_UTIL - show dependent code; FINANCIALS_SYSTEM_PARAMS_ALL; GL_SETS_OF_BOOKS; HR_LOCATIONS_ALL; MTL_UNITS_OF_MEASURE; POA_CUSTOMIZATION_PKG - show dependent code; POA_EDW_SUPPERF - show dependent code; POA_EDW_SUP_PERF_INC; POA_EDW_VARIABLES_PKG - show dependent code; POA_OLTP_GENERIC_PKG - show dependent code; PO_DOC_STYLE_HEADERS; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES; PO_RELEASES_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.POABV_EDW_SUPPLIER_PERFORM_FCV is referenced by following:

APPS: POA_EDW_SUPPLIER_PERFORM_FCV