[Home] [Help] [Dependency Information]
Object Name: | POA_EDW_SUPPLIER_PERFORM_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.POA_EDW_SUPPLIER_PERFORM_FCV |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
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;
|
|
|