Product: | PO - Purchasing |
---|---|
Description: | EDW Contract Agreement Fact Collection View |
Implementation/DBA Data: | APPS.POA_EDW_CONTRACT_AGRMNTS_FCV |
SELECT SEQ_ID
, VIEW_ID
, CONTRACT_PK
, INSTANCE_FK
, BUYER_FK
, APPROVER_FK
, SUPPLIER_SITE_FK
, OPERATING_UNIT_FK
, CREATION_DATE_FK
, APPROVED_DATE_FK
, REVISED_DATE_FK
, ACCPT_DUE_DATE_FK
, START_DATE_FK
, END_DATE_FK
, PRINTED_DATE_FK
, TXN_CUR_DATE_FK
, AP_TERMS_FK
, CLOSED_FK
, PO_TYPE_FK
, SHIP_VIA_FK
, FOB_FK
, FREIGHT_TERMS_FK
, ACCPT_REQUIRED_FK
, FROZEN_FK
, CANCELLED_FK
, USER_HOLD_FK
, CONFIRM_ORDER_FK
, APPROVED_FK
, EDI_PROCESSED_FK
, CONTRACT_EFFECTIVE_FK
, SUP_SITE_GEOG_FK
, BILL_LOCATION_FK
, SHIP_LOCATION_FK
, CONTRACT_NUM_FK
, TXN_CUR_CODE_FK
, TXN_CUR_RATE_TYPE
, /*** MEASURES ***/ AMT_AGREED_T
, AMT_AGREED_G
, AMT_LIMIT_T
, AMT_LIMIT_G
, AMT_MIN_RELEASE_T
, AMT_MIN_RELEASE_G
, AMT_RELEASED_T
, AMT_RELEASED_G
, NUM_DAYS_CREATE_TO_APP
, NUM_DAYS_APP_TO_SEND
, NUM_DAYS_APP_SEND_TO_ACCPT
, /*** ATTRIBUTES ***/ PO_HEADER_ID
, SUPPLIER_NOTE
, COMMENTS
, RECEIVER_NOTE
, REVISION_NUM
, CONTRACT_NUM
, TXN_CUR_RATE
, LAST_UPDATE_DATE
, CREATION_DATE
, DUNS_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_CONTRACT_AGRMNTS_FCV