VIEW: APPS.POA_EDW_SUPPLIER_PERFORM_FCV

Source

View Text - Preformatted

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, NULL user_attribute1, NULL user_attribute2, NULL user_attribute3, NULL user_attribute4, NULL user_attribute5, NULL user_attribute6, NULL user_attribute7, NULL user_attribute8, NULL user_attribute9, NULL user_attribute10, NULL user_attribute11, NULL user_attribute12, NULL user_attribute13, NULL user_attribute14, NULL user_attribute15, to_number(NULL) user_measure1, to_number(NULL) user_measure2, to_number(NULL) user_measure3, to_number(NULL) user_measure4, to_number(NULL) user_measure5, 'NA_EDW' user_fk1, 'NA_EDW' user_fk2, 'NA_EDW' user_fk3, 'NA_EDW' user_fk4, 'NA_EDW' user_fk5 FROM poabv_edw_supplier_perform_fcv

View Text - HTML Formatted

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
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
, NULL USER_ATTRIBUTE6
, NULL USER_ATTRIBUTE7
, NULL USER_ATTRIBUTE8
, NULL USER_ATTRIBUTE9
, NULL USER_ATTRIBUTE10
, NULL USER_ATTRIBUTE11
, NULL USER_ATTRIBUTE12
, NULL USER_ATTRIBUTE13
, NULL USER_ATTRIBUTE14
, NULL USER_ATTRIBUTE15
, TO_NUMBER(NULL) USER_MEASURE1
, TO_NUMBER(NULL) USER_MEASURE2
, TO_NUMBER(NULL) USER_MEASURE3
, TO_NUMBER(NULL) USER_MEASURE4
, TO_NUMBER(NULL) USER_MEASURE5
, 'NA_EDW' USER_FK1
, 'NA_EDW' USER_FK2
, 'NA_EDW' USER_FK3
, 'NA_EDW' USER_FK4
, 'NA_EDW' USER_FK5
FROM POABV_EDW_SUPPLIER_PERFORM_FCV