[Home] [Help] [Dependency Information]
Object Name: | POA_EDW_CONTRACT_AGRMNTS_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.POA_EDW_CONTRACT_AGRMNTS_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 | Sequence number | ||
VIEW_ID | NUMBER | View id | ||
CONTRACT_PK | VARCHAR2 | (71) | Contract Primary Key | |
INSTANCE_FK | VARCHAR2 | (30) | Source database instance FK | |
BUYER_FK | VARCHAR2 | (4000) | Buyer FK | |
APPROVER_FK | VARCHAR2 | (4000) | Approver FK | |
SUPPLIER_SITE_FK | VARCHAR2 | (4000) | Supplier Site FK | |
OPERATING_UNIT_FK | VARCHAR2 | (4000) | Operating Unit FK | |
CREATION_DATE_FK | VARCHAR2 | (4000) | Creation Date FK | |
APPROVED_DATE_FK | VARCHAR2 | (4000) | Approved Date FK | |
REVISED_DATE_FK | VARCHAR2 | (4000) | Revised Date FK | |
ACCPT_DUE_DATE_FK | VARCHAR2 | (4000) | Acceptance Due date FK | |
START_DATE_FK | VARCHAR2 | (4000) | Contract Start Date FK | |
END_DATE_FK | VARCHAR2 | (4000) | Contract end date FK | |
PRINTED_DATE_FK | VARCHAR2 | (4000) | Printed date FK | |
TXN_CUR_DATE_FK | VARCHAR2 | (4000) | Transactional currency rate date FK | |
AP_TERMS_FK | VARCHAR2 | (74) | AP Terms FK | |
CLOSED_FK | VARCHAR2 | (43) | Closed flag FK | |
PO_TYPE_FK | VARCHAR2 | (44) | PO type FK | |
SHIP_VIA_FK | VARCHAR2 | (43) | Ship Via FK | |
FOB_FK | VARCHAR2 | (32) | FOB FK | |
FREIGHT_TERMS_FK | VARCHAR2 | (42) | Freight terms FK | |
ACCPT_REQUIRED_FK | VARCHAR2 | (12) | Acceptance required FK | |
FROZEN_FK | VARCHAR2 | (12) | Frozen flag FK | |
CANCELLED_FK | VARCHAR2 | (12) | Cancelled Flag FK | |
USER_HOLD_FK | VARCHAR2 | (12) | User hold flag FK | |
CONFIRM_ORDER_FK | VARCHAR2 | (12) | Confirm order FK | |
APPROVED_FK | VARCHAR2 | (12) | Approved Flag FK | |
EDI_PROCESSED_FK | VARCHAR2 | (12) | EDI Processed FK | |
CONTRACT_EFFECTIVE_FK | VARCHAR2 | (12) | Contract effective FK | |
SUP_SITE_GEOG_FK | VARCHAR2 | (223) | Supplier Site Geography FK | |
BILL_LOCATION_FK | VARCHAR2 | (243) | Billing Location FK | |
SHIP_LOCATION_FK | VARCHAR2 | (4000) | Shipto location FK | |
CONTRACT_NUM_FK | VARCHAR2 | (71) | Contract number FK | |
TXN_CUR_CODE_FK | VARCHAR2 | (15) | Transactional currency code FK | |
TXN_CUR_RATE_TYPE | VARCHAR2 | (30) | Transactional currency rate type | |
AMT_AGREED_T | NUMBER | Agreed contract Amount (transactional) | ||
AMT_AGREED_G | NUMBER | Agreed contract amount (warehouse) | ||
AMT_LIMIT_T | NUMBER | Amount upper limit (transactional) | ||
AMT_LIMIT_G | NUMBER | Amount upper limit (warehouse) | ||
AMT_MIN_RELEASE_T | NUMBER | Min release amount (transactional) | ||
AMT_MIN_RELEASE_G | NUMBER | Min Released amount (warehouse) | ||
AMT_RELEASED_T | NUMBER | Released amount (transactional) | ||
AMT_RELEASED_G | NUMBER | Released amount (warehouse) | ||
NUM_DAYS_CREATE_TO_APP | NUMBER | Number of days from creation to approval | ||
NUM_DAYS_APP_TO_SEND | NUMBER | Number of days from approval to send (print) | ||
NUM_DAYS_APP_SEND_TO_ACCPT | NUMBER | Number of days from send (print) to acceptance | ||
PO_HEADER_ID | NUMBER | Yes | PO Header ID | |
SUPPLIER_NOTE | VARCHAR2 | (480) | Supplier Note | |
COMMENTS | VARCHAR2 | (240) | Comments | |
RECEIVER_NOTE | VARCHAR2 | (480) | Receiver Note | |
REVISION_NUM | NUMBER | Revision Number | ||
CONTRACT_NUM | VARCHAR2 | (20) | Yes | Contract Number |
TXN_CUR_RATE | NUMBER | Transactional Currency Rate | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
DUNS_FK | VARCHAR2 | (0) | DUNS number FK | |
SIC_CODE_FK | VARCHAR2 | (0) | SIC Code FK | |
COLLECTION_STATUS | VARCHAR2 | (18) | Collection Status | |
USER_ATTRIBUTE1 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE6 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE7 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE8 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE9 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE10 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE11 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE12 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE13 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE14 | VARCHAR2 | (0) | User-defined Attribute | |
USER_ATTRIBUTE15 | VARCHAR2 | (0) | User-defined Attribute | |
USER_MEASURE1 | NUMBER | User-defined Measure | ||
USER_MEASURE2 | NUMBER | User-defined Measure | ||
USER_MEASURE3 | NUMBER | User-defined Measure | ||
USER_MEASURE4 | NUMBER | User-defined Measure | ||
USER_MEASURE5 | NUMBER | User-defined Measure | ||
USER_FK1 | CHAR | (6) | User-defined FK | |
USER_FK2 | CHAR | (6) | User-defined FK | |
USER_FK3 | CHAR | (6) | User-defined FK | |
USER_FK4 | CHAR | (6) | User-defined FK | |
USER_FK5 | CHAR | (6) | User-defined FK |
Cut, paste (and edit) the following text to query this object:
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
, 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
, 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
, 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_CONTRACT_AGRMNTS_FCV;
|
|
|