FND Design Data [Home] [Help]

View: POA_EDW_CONTRACT_F_IV

Product: POA - Purchasing Intelligence (Obsolete)
Description:
Implementation/DBA Data: Not implemented in this database
View Text

SELECT ROWID ROW_ID
, ACCPT_DUE_DATE_FK_KEY
, ACCPT_REQUIRED_FK_KEY
, AMT_AGREED_G
, AMT_AGREED_T
, AMT_LIMIT_G
, AMT_LIMIT_T
, AMT_MIN_RELEASE_G
, AMT_MIN_RELEASE_T
, AMT_RELEASED_G
, AMT_RELEASED_T
, APPROVED_DATE_FK_KEY
, APPROVED_FK_KEY
, APPROVER_FK_KEY
, AP_TERMS_FK_KEY
, BILL_LOCATION_FK_KEY
, BUYER_FK_KEY
, CANCELLED_FK_KEY
, CLOSED_FK_KEY
, COMMENTS
, CONFIRM_ORDER_FK_KEY
, CONTRACT_EFFECTIVE_FK_KEY
, CONTRACT_PK
, CONTRACT_PK_KEY
, CREATION_DATE_FK_KEY
, CREATION_DATE
, EDI_PROCESSED_FK_KEY
, END_DATE_FK_KEY
, FOB_FK_KEY
, FREIGHT_TERMS_FK_KEY
, FROZEN_FK_KEY
, INSTANCE_FK_KEY
, LAST_UPDATE_DATE
, NUM_DAYS_APP_SEND_TO_ACCPT
, NUM_DAYS_APP_TO_SEND
, NUM_DAYS_CREATE_TO_APP
, OPERATING_UNIT_FK_KEY
, PO_HEADER_ID
, PO_TYPE_FK_KEY
, PRINTED_DATE_FK_KEY
, RECEIVER_NOTE
, REVISED_DATE_FK_KEY
, REVISION_NUM
, SHIP_LOCATION_FK_KEY
, SHIP_VIA_FK_KEY
, START_DATE_FK_KEY
, SUPPLIER_NOTE
, SUPPLIER_SITE_FK_KEY
, SUP_SITE_GEOG_FK_KEY
, TXN_CUR_CODE_FK_KEY
, TXN_CUR_DATE_FK_KEY
, TXN_CUR_RATE
, TXN_CUR_RATE_FK_KEY
, USER_ATTRIBUTE1
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_FK1_KEY
, USER_FK2_KEY
, USER_FK3_KEY
, USER_FK4_KEY
, USER_FK5_KEY
, USER_HOLD_FK_KEY
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, ' ' OPERATION_CODE
FROM POA_EDW_CONTRACT_F

Columns

Name
ROW_ID
ACCPT_DUE_DATE_FK_KEY
ACCPT_REQUIRED_FK_KEY
AMT_AGREED_G
AMT_AGREED_T
AMT_LIMIT_G
AMT_LIMIT_T
AMT_MIN_RELEASE_G
AMT_MIN_RELEASE_T
AMT_RELEASED_G
AMT_RELEASED_T
APPROVED_DATE_FK_KEY
APPROVED_FK_KEY
APPROVER_FK_KEY
AP_TERMS_FK_KEY
BILL_LOCATION_FK_KEY
BUYER_FK_KEY
CANCELLED_FK_KEY
CLOSED_FK_KEY
COMMENTS
CONFIRM_ORDER_FK_KEY
CONTRACT_EFFECTIVE_FK_KEY
CONTRACT_PK
CONTRACT_PK_KEY
CREATION_DATE_FK_KEY
CREATION_DATE
EDI_PROCESSED_FK_KEY
END_DATE_FK_KEY
FOB_FK_KEY
FREIGHT_TERMS_FK_KEY
FROZEN_FK_KEY
INSTANCE_FK_KEY
LAST_UPDATE_DATE
NUM_DAYS_APP_SEND_TO_ACCPT
NUM_DAYS_APP_TO_SEND
NUM_DAYS_CREATE_TO_APP
OPERATING_UNIT_FK_KEY
PO_HEADER_ID
PO_TYPE_FK_KEY
PRINTED_DATE_FK_KEY
RECEIVER_NOTE
REVISED_DATE_FK_KEY
REVISION_NUM
SHIP_LOCATION_FK_KEY
SHIP_VIA_FK_KEY
START_DATE_FK_KEY
SUPPLIER_NOTE
SUPPLIER_SITE_FK_KEY
SUP_SITE_GEOG_FK_KEY
TXN_CUR_CODE_FK_KEY
TXN_CUR_DATE_FK_KEY
TXN_CUR_RATE
TXN_CUR_RATE_FK_KEY
USER_ATTRIBUTE1
USER_ATTRIBUTE10
USER_ATTRIBUTE11
USER_ATTRIBUTE12
USER_ATTRIBUTE13
USER_ATTRIBUTE14
USER_ATTRIBUTE15
USER_ATTRIBUTE2
USER_ATTRIBUTE3
USER_ATTRIBUTE4
USER_ATTRIBUTE5
USER_ATTRIBUTE6
USER_ATTRIBUTE7
USER_ATTRIBUTE8
USER_ATTRIBUTE9
USER_FK1_KEY
USER_FK2_KEY
USER_FK3_KEY
USER_FK4_KEY
USER_FK5_KEY
USER_HOLD_FK_KEY
USER_MEASURE1
USER_MEASURE2
USER_MEASURE3
USER_MEASURE4
USER_MEASURE5
OPERATION_CODE