eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.POABV_EDW_CONTRACT_AGRMNTS_FCV

Object Details

Object Name:	POABV_EDW_CONTRACT_AGRMNTS_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POABV_EDW_CONTRACT_AGRMNTS_FCV
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

EDW Contract Agreement Fact Collection View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SEQ_ID	NUMBER			Sequence Id
VIEW_ID	NUMBER			View Id
CONTRACT_PK	VARCHAR2	(71)		Contract PK
INSTANCE_FK	VARCHAR2	(30)		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)
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 Date FK
AP_TERMS_FK	VARCHAR2	(74)		AP Terms FK
CLOSED_FK	VARCHAR2	(43)		Closed 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 FK
CONFIRM_ORDER_FK	VARCHAR2	(12)		Confirm Order FK
APPROVED_FK	VARCHAR2	(12)		Approved 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)		Ship-to 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			Amount agreed (transactional)
AMT_AGREED_G	NUMBER			Amount agreed (global currency)
AMT_LIMIT_T	NUMBER			Amount Limit (transactional)
AMT_LIMIT_G	NUMBER			Amount Limit (global)
AMT_MIN_RELEASE_T	NUMBER			Amount min release (transactional)
AMT_MIN_RELEASE_G	NUMBER			Amount min release (global)
AMT_RELEASED_T	NUMBER			amount released (transactional)
AMT_RELEASED_G	NUMBER			amount released (global)
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
NUM_DAYS_APP_SEND_TO_ACCPT	NUMBER			number of days from send 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			Trasactional 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
_DF:PO_HDR:_EDW	CHAR	(21)		flexfield

Query Text

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
,      _DF:PO_HDR:_EDW
FROM APPS.POABV_EDW_CONTRACT_AGRMNTS_FCV;

Dependencies

[top of page]

APPS.POABV_EDW_CONTRACT_AGRMNTS_FCV references the following:

APPS: EDW_CURRENCY - show dependent code; EDW_GEOGRAPHY_PKG - show dependent code; EDW_HR_PERSON_PKG - show dependent code; EDW_LOCAL_INSTANCE; EDW_ORGANIZATION_PKG - show dependent code; EDW_TIME_PKG - show dependent code; EDW_TRD_PARTNER_PKG - show dependent code; FINANCIALS_SYSTEM_PARAMS_ALL; GL_SETS_OF_BOOKS; HR_LOCATIONS_ALL; POA_EDW_CONTRACT_INC; POA_EDW_SPEND_PKG - show dependent code; POA_OLTP_GENERIC_PKG - show dependent code; PO_HEADERS_ALL; PO_VENDOR_SITES_ALL

APPS.POABV_EDW_CONTRACT_AGRMNTS_FCV is referenced by following:

APPS: POA_EDW_CONTRACT_AGRMNTS_FCV