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.POA_EDW_CONTRACT_AGRMNTS_FCV

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

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

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
,      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;

Dependencies

[top of page]

APPS.POA_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_ORGANIZATION_PKG - show dependent code; EDW_TIME_PKG - show dependent code; EDW_TRD_PARTNER_PKG - show dependent code; POABV_EDW_CONTRACT_AGRMNTS_FCV; POA_EDW_SPEND_PKG - show dependent code; POA_OLTP_GENERIC_PKG - show dependent code

APPS.POA_EDW_CONTRACT_AGRMNTS_FCV is referenced by following:

APPS: POA_EDW_CONTRACT_F_C - show dependent code