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

SchemaAPPS
PL/SQL PackageEDW_CURRENCY - show dependent code
PL/SQL PackageEDW_GEOGRAPHY_PKG - show dependent code
PL/SQL PackageEDW_HR_PERSON_PKG - show dependent code
PL/SQL PackageEDW_ITEMS_PKG - show dependent code
SynonymEDW_LOCAL_INSTANCE
PL/SQL PackageEDW_LOOKUP_PKG - show dependent code
PL/SQL PackageEDW_ORGANIZATION_PKG - show dependent code
PL/SQL PackageEDW_TRD_PARTNER_PKG - show dependent code
PL/SQL PackageEDW_UTIL - show dependent code
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
ViewGL_SETS_OF_BOOKS
SynonymHR_LOCATIONS_ALL
SynonymMTL_UNITS_OF_MEASURE
PL/SQL PackagePOA_CUSTOMIZATION_PKG - show dependent code
PL/SQL PackagePOA_EDW_SUPPERF - show dependent code
SynonymPOA_EDW_SUP_PERF_INC
PL/SQL PackagePOA_EDW_VARIABLES_PKG - show dependent code
PL/SQL PackagePOA_OLTP_GENERIC_PKG - show dependent code
SynonymPO_DOC_STYLE_HEADERS
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_LINE_TYPES
SynonymPO_RELEASES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
APPS.POABV_EDW_SUPPLIER_PERFORM_FCV is referenced by following:

SchemaAPPS
ViewPOA_EDW_SUPPLIER_PERFORM_FCV