DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.POA_EDW_SUPPLIER_PERFORM_FCV

Object Details
Object Name: POA_EDW_SUPPLIER_PERFORM_FCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POA_EDW_SUPPLIER_PERFORM_FCV
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER

VIEW_ID NUMBER

SUP_PERF_PK VARCHAR2 (71)
SUPPLIER_ITEM_FK VARCHAR2 (282)
PURCH_CLASS_FK VARCHAR2 (4000)
INVOICE_DATE_FK VARCHAR2 (76)
EDW_BASE_UOM_FK VARCHAR2 (4000)
EDW_UOM_FK VARCHAR2 (4000)
INSTANCE_FK VARCHAR2 (30)
SUPPLIER_SITE_FK VARCHAR2 (4000)
SHIP_TO_ORG_FK VARCHAR2 (4000)
SHIP_LOCATION_FK VARCHAR2 (4000)
SUP_SITE_GEOG_FK VARCHAR2 (223)
ITEM_FK VARCHAR2 (4000)
BUYER_FK VARCHAR2 (4000)
DATE_DIM_FK VARCHAR2 (76)
PROMISED_DATE_FK VARCHAR2 (76)
NEED_BY_DATE_FK VARCHAR2 (76)
CREATION_DATE_FK VARCHAR2 (76)
FIRST_REC_DATE_FK VARCHAR2 (76)
LST_ACCPT_DATE_FK VARCHAR2 (76)
APPROVAL_DATE_FK VARCHAR2 (76)
AP_TERMS_FK VARCHAR2 (74)
TXN_CUR_CODE_FK VARCHAR2 (15)
PRICE_TYPE_FK VARCHAR2 (39)
CLOSED_CODE_FK VARCHAR2 (48)
PO_LINE_TYPE_FK VARCHAR2 (25) Yes
IPV_T NUMBER

IPV_G NUMBER

PRICE_T VARCHAR2 (40)
PRICE_G VARCHAR2 (40)
MARKET_PRICE_T VARCHAR2 (40)
MARKET_PRICE_G VARCHAR2 (40)
LIST_PRICE_T VARCHAR2 (40)
LIST_PRICE_G VARCHAR2 (40)
TARGET_PRICE_T NUMBER

TARGET_PRICE_G VARCHAR2 (40)
AMT_PURCHASED_G VARCHAR2 (40)
AMT_PURCHASED_T VARCHAR2 (40)
QTY_ORDERED_B VARCHAR2 (40)
QTY_CANCELLED_B NUMBER

QTY_SHIPPED_B NUMBER

QTY_RECEIVED_B NUMBER

QTY_REJECTED_B NUMBER

QTY_ACCEPTED_B NUMBER

QTY_DELIVERED_B NUMBER

NUM_RECEIPT_LINES NUMBER

NUM_EARLY_RECEIPT NUMBER

NUM_LATE_RECEIPT NUMBER

NUM_ONTIME_BEFDUE NUMBER

NUM_ONTIME_AFTDUE NUMBER

NUM_ONTIME_ONDUE NUMBER

NUM_SUBS_RECEIPT NUMBER

QTY_EARLY_RECEIPT_B NUMBER

QTY_LATE_RECEIPT_B NUMBER

QTY_PAST_DUE_B NUMBER

QTY_ONTIME_BEFDUE_B NUMBER

QTY_ONTIME_AFTDUE_B NUMBER

QTY_ONTIME_ONDUE_B NUMBER

QTY_SUBS_RECEIPT_B NUMBER

DAYS_EARLY_REC NUMBER

DAYS_LATE_REC NUMBER

QTY_RECEIVED_TOL NUMBER

NUM_DAYS_TO_INVOICE VARCHAR2 (40)
RCV_CLOSE_TOL NUMBER

LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
PO_NUMBER VARCHAR2 (20) Yes
CONTRACT_NUM VARCHAR2 (20)
RELEASE_NUM NUMBER

OPERATION_CODE VARCHAR2 (0)
DUNS_FK VARCHAR2 (0)
UNSPSC_FK VARCHAR2 (0)
SIC_CODE_FK VARCHAR2 (0)
COLLECTION_STATUS VARCHAR2 (18)
USER_ATTRIBUTE1 VARCHAR2 (0)
USER_ATTRIBUTE2 VARCHAR2 (0)
USER_ATTRIBUTE3 VARCHAR2 (0)
USER_ATTRIBUTE4 VARCHAR2 (0)
USER_ATTRIBUTE5 VARCHAR2 (0)
USER_ATTRIBUTE6 VARCHAR2 (0)
USER_ATTRIBUTE7 VARCHAR2 (0)
USER_ATTRIBUTE8 VARCHAR2 (0)
USER_ATTRIBUTE9 VARCHAR2 (0)
USER_ATTRIBUTE10 VARCHAR2 (0)
USER_ATTRIBUTE11 VARCHAR2 (0)
USER_ATTRIBUTE12 VARCHAR2 (0)
USER_ATTRIBUTE13 VARCHAR2 (0)
USER_ATTRIBUTE14 VARCHAR2 (0)
USER_ATTRIBUTE15 VARCHAR2 (0)
USER_MEASURE1 NUMBER

USER_MEASURE2 NUMBER

USER_MEASURE3 NUMBER

USER_MEASURE4 NUMBER

USER_MEASURE5 NUMBER

USER_FK1 CHAR (6)
USER_FK2 CHAR (6)
USER_FK3 CHAR (6)
USER_FK4 CHAR (6)
USER_FK5 CHAR (6)
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
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
FROM APPS.POA_EDW_SUPPLIER_PERFORM_FCV;

Dependencies

[top of page]

APPS.POA_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
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
ViewPOABV_EDW_SUPPLIER_PERFORM_FCV
PL/SQL PackagePOA_CUSTOMIZATION_PKG - show dependent code
PL/SQL PackagePOA_EDW_SUPPERF - show dependent code
PL/SQL PackagePOA_EDW_VARIABLES_PKG - show dependent code
PL/SQL PackagePOA_OLTP_GENERIC_PKG - show dependent code
APPS.POA_EDW_SUPPLIER_PERFORM_FCV is referenced by following:

SchemaAPPS
Package BodyPOA_EDW_SUP_PERF_F_C - show dependent code