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_AGREEMENT_LINES_FCV

Object Details

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

View Type

A Business Intelligence System view

EDW Contract Agreement LIne Fact Collection View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SEQ_ID	NUMBER			Sequence Id
VIEW_ID	NUMBER			View Id
AGREE_LN_INST_PK	VARCHAR2	(71)		Agreement Line INstance PK
INSTANCE_FK	VARCHAR2	(30)		Instance FK
BUYER_FK	VARCHAR2	(4000)		Buyer Fk
APPROVER_FK	VARCHAR2	(4000)		Approver FK
ITEM_REVISION_FK	VARCHAR2	(4000)		Item Revision FK
SUPPLIER_SITE_FK	VARCHAR2	(4000)		Supplier Site FK
OPERATING_UNIT_FK	VARCHAR2	(4000)		Operating Unit Fk
PO_CREATE_DATE_FK	VARCHAR2	(4000)		PO Creation Date FK
LNE_CREAT_DATE_FK	VARCHAR2	(4000)		PO Line Creation Date FK
APPROVED_DATE_FK	VARCHAR2	(4000)		Approved Date FK
REVISED_DATE_FK	VARCHAR2	(4000)		Revised Date FK
START_DATE_FK	VARCHAR2	(4000)		Start Date FK
END_DATE_FK	VARCHAR2	(4000)		End date FK
ACCPT_DUE_DATE_FK	VARCHAR2	(4000)		Acceptance Due Date FK
TXN_CUR_DATE_FK	VARCHAR2	(4000)		Transaction Currency Date FK
PO_PRINT_DATE_FK	VARCHAR2	(4000)		PO Print Date FK
AP_TERMS_FK	VARCHAR2	(74)		AP Terms FK
PO_CLOSED_FK	VARCHAR2	(43)		PO 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
TXN_REASON_FK	VARCHAR2	(47)		Transaction Reason FK
PRICE_TYPE_FK	VARCHAR2	(39)		Price Type FK
PRICE_BREAK_FK	VARCHAR2	(45)		Price Break FK
ACCPT_REQUIRED_FK	VARCHAR2	(12)		Acceptance Required FK
FROZEN_FK	VARCHAR2	(12)		Frozen FK
APPROVED_FK	VARCHAR2	(12)		Approved FK
USER_HOLD_FK	VARCHAR2	(12)		User Hold FK
CONFIRM_ORDER_FK	VARCHAR2	(12)		Confirm Order FK
SUPPLY_AGREE_FK	VARCHAR2	(12)		Supply Agree FK
NEG_BY_PREPARE_FK	VARCHAR2	(12)		Neg By Prepare FK
CANCELLED_FK	VARCHAR2	(12)		Cancelled FK
LNE_CLOSED_FK	VARCHAR2	(12)		Line Closed FK
EDI_PROCESSED_FK	VARCHAR2	(12)		EDI Processed FK
BASE_UOM_FK	VARCHAR2	(4000)		Base Unit of Measure FK
TXN_UOM_FK	VARCHAR2	(4000)		Transaction UOM FK
BILL_LOCATION_FK	VARCHAR2	(243)		Billing Location FK
SHIP_LOCATION_FK	VARCHAR2	(4000)		Ship-to location FK
SUP_SITE_GEOG_FK	VARCHAR2	(223)		Supplier Site Geography FK
TXN_CUR_CODE_FK	VARCHAR2	(15)		Transaction Currency Code FK
TXN_CUR_RATE_TYPE	VARCHAR2	(30)		Transaction Currency Rate Type
PO_LINE_TYPE_FK	VARCHAR2	(25)	Yes	PO Line Type FK
CONTRACT_EFFECTIVE_FK	VARCHAR2	(12)		Contract Effective FK
SUPPLIER_ITEM_NUM_FK	VARCHAR2	(4000)		Supplier Item Number FK
AMT_AGREED_T	NUMBER			Amount Agreed (transactional)
AMT_AGREED_G	NUMBER			Amounted Agreed (Global currency)
QTY_ORDERED_T	NUMBER			Quantity Ordered (transactional)
QTY_MIN_ORDER_T	NUMBER			Quantity mininum order (transactional)
QTY_MAX_ORDER_T	NUMBER			Quantity Maximum order (transactional)
MARKET_PRICE_T	NUMBER			Market Prcie (transactional)
MARKET_PRICE_G	NUMBER			Market Price (global currency)
PRICE_LIMIT_T	NUMBER			price limit (transactinoal currency)
PRICE_LIMIT_G	NUMBER			Price limit (global currency)
LIST_PRICE_T	NUMBER			List Price (transactional currency)
LIST_PRICE_G	NUMBER			List Price (global currency)
UNIT_PRICE_T	NUMBER			Unit Pirce (transactional currency)
UNIT_PRICE_G	NUMBER			Unit Price (global currency)
AMT_MIN_RELEASE_T	NUMBER			mininum Amount to release (transactional)
AMT_MIN_RELEASE_G	NUMBER			min amount to release (global)
QTY_AGREED_T	NUMBER			Quantity agreed (transactional)
QTY_RELEASED_T	NUMBER			Quantity released (transactional)
AMT_RELEASED_T	NUMBER			amount released (transactional)
AMT_RELEASED_G	NUMBER			Amount released (global currency)
NUM_DAYS_CREATE_TO_APP	NUMBER			Days from creation to approval
NUM_DAYS_APP_TO_SEND	NUMBER			Days from approval to send
NUM_DAYS_APP_SEND_TO_ACCPT	NUMBER			Days from send to acceptance
ITEM_ID	NUMBER			Item Id
ITEM_DESCRIPTION	VARCHAR2	(240)		Item Description
PO_SUPPLIER_NOTE	VARCHAR2	(480)		Supplier Note
COMMENTS	VARCHAR2	(240)		Comments
RECEIVER_NOTE	VARCHAR2	(480)		Receiver Note
PO_HEADER_ID	NUMBER		Yes	PO Header Id
PO_LINE_ID	NUMBER		Yes	PO Line Id
CANCEL_REASON	VARCHAR2	(240)		Cancel Reason
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
DUNS_FK	VARCHAR2	(0)		DUNS number FK
UNSPSC_FK	VARCHAR2	(0)		UNSPSC number FK
SIC_CODE_FK	VARCHAR2	(0)		SIC Code FK
COLLECTION_STATUS	VARCHAR2	(18)		Collection Status
_DF:PO_HDR:_EDW	CHAR	(21)		flexfield
_DF:PO_LINES:_EDW	CHAR	(19)		flexfield

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SEQ_ID
,      VIEW_ID
,      AGREE_LN_INST_PK
,      INSTANCE_FK
,      BUYER_FK
,      APPROVER_FK
,      ITEM_REVISION_FK
,      SUPPLIER_SITE_FK
,      OPERATING_UNIT_FK
,      PO_CREATE_DATE_FK
,      LNE_CREAT_DATE_FK
,      APPROVED_DATE_FK
,      REVISED_DATE_FK
,      START_DATE_FK
,      END_DATE_FK
,      ACCPT_DUE_DATE_FK
,      TXN_CUR_DATE_FK
,      PO_PRINT_DATE_FK
,      AP_TERMS_FK
,      PO_CLOSED_FK
,      PO_TYPE_FK
,      SHIP_VIA_FK
,      FOB_FK
,      FREIGHT_TERMS_FK
,      TXN_REASON_FK
,      PRICE_TYPE_FK
,      PRICE_BREAK_FK
,      ACCPT_REQUIRED_FK
,      FROZEN_FK
,      APPROVED_FK
,      USER_HOLD_FK
,      CONFIRM_ORDER_FK
,      SUPPLY_AGREE_FK
,      NEG_BY_PREPARE_FK
,      CANCELLED_FK
,      LNE_CLOSED_FK
,      EDI_PROCESSED_FK
,      BASE_UOM_FK
,      TXN_UOM_FK
,      BILL_LOCATION_FK
,      SHIP_LOCATION_FK
,      SUP_SITE_GEOG_FK
,      TXN_CUR_CODE_FK
,      TXN_CUR_RATE_TYPE
,      PO_LINE_TYPE_FK
,      CONTRACT_EFFECTIVE_FK
,      SUPPLIER_ITEM_NUM_FK
,      AMT_AGREED_T
,      AMT_AGREED_G
,      QTY_ORDERED_T
,      QTY_MIN_ORDER_T
,      QTY_MAX_ORDER_T
,      MARKET_PRICE_T
,      MARKET_PRICE_G
,      PRICE_LIMIT_T
,      PRICE_LIMIT_G
,      LIST_PRICE_T
,      LIST_PRICE_G
,      UNIT_PRICE_T
,      UNIT_PRICE_G
,      AMT_MIN_RELEASE_T
,      AMT_MIN_RELEASE_G
,      QTY_AGREED_T
,      QTY_RELEASED_T
,      AMT_RELEASED_T
,      AMT_RELEASED_G
,      NUM_DAYS_CREATE_TO_APP
,      NUM_DAYS_APP_TO_SEND
,      NUM_DAYS_APP_SEND_TO_ACCPT
,      ITEM_ID
,      ITEM_DESCRIPTION
,      PO_SUPPLIER_NOTE
,      COMMENTS
,      RECEIVER_NOTE
,      PO_HEADER_ID
,      PO_LINE_ID
,      CANCEL_REASON
,      LAST_UPDATE_DATE
,      DUNS_FK
,      UNSPSC_FK
,      SIC_CODE_FK
,      COLLECTION_STATUS
,      _DF:PO_HDR:_EDW
,      _DF:PO_LINES:_EDW
FROM APPS.POABV_EDW_AGREEMENT_LINES_FCV;

Dependencies

[top of page]

APPS.POABV_EDW_AGREEMENT_LINES_FCV references the following:

APPS: EDW_CURRENCY - show dependent code; EDW_GEOGRAPHY_PKG - show dependent code; EDW_HR_PERSON_PKG - show dependent code; EDW_ITEMS_PKG - show dependent code; EDW_LOCAL_INSTANCE; EDW_ORGANIZATION_PKG - show dependent code; EDW_SUPPLIER_ITEM_PKG - show dependent code; EDW_TIME_PKG - show dependent code; EDW_TRD_PARTNER_PKG - show dependent code; EDW_UTIL - show dependent code; FINANCIALS_SYSTEM_PARAMS_ALL; GL_SETS_OF_BOOKS; HR_LOCATIONS_ALL; MTL_UNITS_OF_MEASURE; POA_EDW_ALINES_INC; POA_EDW_SPEND_PKG - show dependent code; POA_OLTP_GENERIC_PKG - show dependent code; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_TYPES; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.POABV_EDW_AGREEMENT_LINES_FCV is referenced by following:

APPS: POA_EDW_AGREEMENT_LINES_FCV