[Home] [Help]
| Product: | POA - Purchasing Intelligence (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ROWID ROW_ID
, APPROVAL_DATE_FK_KEY
, AP_TERMS_FK_KEY
, BUYER_FK_KEY
, CLOSED_CODE_FK_KEY
, CREATION_DATE_FK_KEY
, DATE_DIM_FK_KEY
, EDW_BASE_UOM_FK_KEY
, EDW_UOM_FK_KEY
, FIRST_REC_DATE_FK_KEY
, INSTANCE_FK_KEY
, INVOICE_DATE_FK_KEY
, ITEM_FK_KEY
, LST_ACCPT_DATE_FK_KEY
, NEED_BY_DATE_FK_KEY
, PO_LINE_TYPE_FK_KEY
, PRICE_TYPE_FK_KEY
, PROMISED_DATE_FK_KEY
, PURCH_CLASS_FK_KEY
, SHIP_LOCATION_FK_KEY
, SHIP_TO_ORG_FK_KEY
, SUPPLIER_ITEM_FK_KEY
, SUPPLIER_SITE_FK_KEY
, SUP_SITE_GEOG_FK_KEY
, TXN_CUR_CODE_FK_KEY
, AMT_PURCHASED_G
, CONTRACT_NUM
, CREATION_DATE
, DAYS_EARLY_REC
, DAYS_LATE_REC
, IPV_G_B
, IPV_G_T
, LAST_UPDATE_DATE
, LIST_PRICE_G_B
, LIST_PRICE_G_T
, MARKET_PRICE_G_B
, MARKET_PRICE_G_T
, NUM_DAYS_TO_INVOICE
, NUM_EARLY_RECEIPT
, NUM_LATE_RECEIPT
, NUM_ONTIME_AFTDUE
, NUM_ONTIME_BEFDUE
, NUM_ONTIME_ONDUE
, NUM_RECEIPT_LINES
, NUM_SUBS_RECEIPT
, PO_NUMBER
, PRICE_G_B
, PRICE_G_T
, QTY_ACCEPTED_B
, QTY_CANCELLED_B
, QTY_DELIVERED_B
, QTY_EARLY_RECEIPT_B
, QTY_LATE_RECEIPT_B
, QTY_ONTIME_AFTDUE_B
, QTY_ONTIME_BEFDUE_B
, QTY_ONTIME_ONDUE_B
, QTY_ORDERED_B
, QTY_PAST_DUE_B
, QTY_RECEIVED_B
, QTY_RECEIVED_TOL
, QTY_REJECTED_B
, QTY_SHIPPED_B
, QTY_SUBS_RECEIPT_B
, RCV_CLOSE_TOL
, RELEASE_NUM
, SUP_PERF_PK
, SUP_PERF_PK_KEY
, TARGET_PRICE_G_B
, TARGET_PRICE_G_T
, 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_FK1_KEY
, USER_FK2_KEY
, USER_FK3_KEY
, USER_FK4_KEY
, USER_FK5_KEY
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, ' ' OPERATION_CODE
FROM POA_EDW_SUP_PERF_F