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_PO_DISTRIBUTIONS_FCV

Object Details

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

View Type

A Business Intelligence System view

EDW PO Distribution Fact Collection View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
GLOBAL_CURRENCY_RATE	NUMBER			Global Currency Rate
SEQ_ID	NUMBER			Sequence number
VIEW_ID	NUMBER			View id
PO_DIST_INST_PK	VARCHAR2	(71)		PO Distribution instance Primary Key
SUPPLIER_ITEM_FK	VARCHAR2	(282)		Supplier Item FK
INSTANCE_FK	VARCHAR2	(30)		Source database instance FK
PURCH_CLASS_FK	CHAR	(6)		Purchase Class FK
BUYER_FK	VARCHAR2	(85)		Buyer FK
DELIVER_TO_FK	VARCHAR2	(85)		Deliver to FK
APPROVER_FK	VARCHAR2	(85)		Approver FK
ITEM_FK	VARCHAR2	(4000)		Item FK
SUPPLIER_SITE_FK	VARCHAR2	(126)		Supplier Site FK
SHIP_TO_ORG_FK	VARCHAR2	(71)		Ship-to Organization FK
DESTIN_ORG_FK	VARCHAR2	(71)		Destination Organization FK
SOB_FK	VARCHAR2	(71)		Set of Books FK
SHIP_LOCATION_FK	VARCHAR2	(4000)		Shipto location FK
BILL_LOCATION_FK	VARCHAR2	(243)		Billing Location FK
DELIV_LOCATION_FK	VARCHAR2	(4000)		Delivery Location FK
SUP_SITE_GEOG_FK	VARCHAR2	(223)		Supplier Site Geography FK
TASK_FK	VARCHAR2	(78)		Task FK
PO_CREATE_DATE_FK	VARCHAR2	(76)		PO Creation Date FK
LNE_CREAT_DATE_FK	VARCHAR2	(76)		PO LIne creation date FK
SHP_CREAT_DATE_FK	VARCHAR2	(76)		Shipment creation date FK
DST_CREAT_DATE_FK	VARCHAR2	(76)		Distribution creation date FK
PO_APP_DATE_FK	VARCHAR2	(76)		PO Approval Date FK
REVISED_DATE_FK	VARCHAR2	(76)		Revised Date FK
ACCPT_DUE_DATE_FK	VARCHAR2	(76)		Acceptance Due Date FK
RELEASE_DATE_FK	VARCHAR2	(76)		Release Date FK
SHP_APP_DATE_FK	VARCHAR2	(76)		Shipment approval Date FK
LST_ACCPT_DATE_FK	VARCHAR2	(76)		Last acceptance Date FK
NEED_BY_DATE_FK	VARCHAR2	(76)		Need-by date FK
PROMISED_DATE_FK	VARCHAR2	(76)		Promised Date FK
PRINTED_DATE_FK	VARCHAR2	(76)		Printed Date FK
TXN_CUR_DATE_FK	VARCHAR2	(76)		Transaction Currency date FK
REQ_CREAT_DATE_FK	VARCHAR2	(76)		Requisition creation date FK
REQ_APPRV_DATE_FK	VARCHAR2	(76)		Requisition Approval Date FK
PO_ACCEPT_DATE_FK	VARCHAR2	(76)		PO Acceptance date FK
AP_TERMS_FK	VARCHAR2	(74)		AP Terms FK
SHIPMENT_TYPE_FK	VARCHAR2	(42)		Shipment 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
SHP_CLOSED_FK	VARCHAR2	(48)		Shipment Closed FK
DESTIN_TYPE_FK	VARCHAR2	(45)		Destination Type FK
CONTRACT_TYPE_FK	VARCHAR2	(27)		Contract Type FK
RCV_ROUTING_FK	VARCHAR2	(96)		Receipt Routing FK
ACCPT_REQUIRED_FK	VARCHAR2	(12)		Acceptance Required FK
FROZEN_FK	VARCHAR2	(12)		Frozen Flag FK
RELEASE_HOLD_FK	VARCHAR2	(12)		Release Hold FK
CONFIRM_ORDER_FK	VARCHAR2	(12)		Confirm Order FK
NEG_BY_PREPARE_FK	VARCHAR2	(12)		Negotiated by Preparer FK
SUB_RECEIPT_FK	VARCHAR2	(12)		Substitute Receipts Flag FK
SHP_APPROVED_FK	VARCHAR2	(12)		Shipment Approved FK
SHP_CANCELLED_FK	VARCHAR2	(12)		Shipment Canceled FK
INSPECTION_REQ_FK	VARCHAR2	(12)		Inspection Required FK
RECEIPT_REQ_FK	VARCHAR2	(12)		Receipt Required FK
ACCRUED_FK	VARCHAR2	(12)		Accrued FK
DST_ENCUMB_FK	VARCHAR2	(12)		Encumbered FK
ONLINE_REQ_FK	VARCHAR2	(12)		online requisition FK
SHP_TAXABLE_FK	VARCHAR2	(12)		Shipment taxable FK
EDI_PROCESSED_FK	VARCHAR2	(12)		EDI Processed FK
PCARD_PROCESS_FK	VARCHAR2	(12)		P-card process FK
APPRV_SUPPLIER_FK	VARCHAR2	(4000)		apprv supplier fk
EDW_BASE_UOM_FK	VARCHAR2	(4000)		base UOM FK
EDW_UOM_FK	VARCHAR2	(4000)		UOM FK
TXN_CUR_CODE_FK	VARCHAR2	(15)		Transactional currency code FK
PO_LINE_TYPE_FK	VARCHAR2	(25)	Yes	PO Line Type FK
CHECK_CUT_DATE_FK	VARCHAR2	(76)		check cut date FK
INV_RECEIVED_DATE_FK	VARCHAR2	(76)		Invoice Received Date FK
INV_CREATION_DATE_FK	VARCHAR2	(76)		Invoice creation date FK
GOODS_RECEIVED_DATE_FK	VARCHAR2	(76)		Goods received date FK
DUNS_FK	VARCHAR2	(0)		DUNS number FK
UNSPSC_FK	VARCHAR2	(0)		UNSPSC number FK
SIC_CODE_FK	VARCHAR2	(0)		SIC code FK
PO_CREATION_CYCLE_TIME	NUMBER			PO creation cycle time
ORDER_TO_PAY_CYCLE_TIME	VARCHAR2	(40)		Order to pay cycle time
RECEIVE_TO_PAY_CYCL_TIME	NUMBER			receive to pay cycle time
INV_CREATION_CYCLE_TIME	VARCHAR2	(40)		invoice creation cycle time
INV_TO_PAY_CYCLE_TIME	VARCHAR2	(40)		invoice to pay cycle time
IPV_T	VARCHAR2	(40)		invoice price variance (transactional)
IPV_G	VARCHAR2	(40)		invoice price variance (global)
AMT_PURCHASED_T	VARCHAR2	(40)		amount purchased (transactional)
AMT_PURCHASED_G	VARCHAR2	(40)		amount purchased (global)
AMT_CONTRACT_T	VARCHAR2	(40)		Contract purchases amount (transactional)
AMT_CONTRACT_G	VARCHAR2	(40)		Contract purchases amount (global currency)
AMT_NONCONTRACT_T	VARCHAR2	(40)		non-Contract purchases amount (transactional)
AMT_NONCONTRACT_G	VARCHAR2	(40)		non-Contract purchases amount (global)
AMT_LEAKAGE_T	VARCHAR2	(40)		Contract leakage amount (transactional)
AMT_LEAKAGE_G	VARCHAR2	(40)		Contract leakage (global currency)
POTENTIAL_SVG_T	VARCHAR2	(40)		Potential Savings (transactional)
POTENTIAL_SVG_G	VARCHAR2	(40)		Potential Savings (global currency)
AMT_BILLED_T	VARCHAR2	(40)		Amount Billed (transactional)
AMT_BILLED_G	VARCHAR2	(40)		Amount Billed (global)
QTY_BILLED_B	VARCHAR2	(40)		Quantity Billed (functional)
QTY_CANCELLED_B	NUMBER			Quantity cancelled (functional)
QTY_DELIVERED_B	NUMBER			Quantity delivered (functional)
QTY_ORDERED_B	VARCHAR2	(40)		Quantity Ordered (functional)
PRICE_T	VARCHAR2	(40)		Price (transactional)
PRICE_G	VARCHAR2	(40)		Price (global currency)
LIST_PRC_UNIT_T	VARCHAR2	(40)		list price per unit (transactional)
LIST_PRC_UNIT_G	VARCHAR2	(40)		list price per unit (global)
MARKET_PRICE_T	VARCHAR2	(40)		market price (transactional)
MARKET_PRICE_G	VARCHAR2	(40)		market price (global)
PRICE_LIMIT_T	VARCHAR2	(40)		price limit (transactional)
PRICE_LIMIT_G	VARCHAR2	(40)		price limit (global)
ITEM_ID	NUMBER			Item Id
ITEM_DESCRIPTION	VARCHAR2	(240)		Item Description
SUPPLIER_NOTE	VARCHAR2	(480)		Supplier Note
LNE_SUPPLIER_NOTE	VARCHAR2	(480)		line level supplier note
PO_COMMENTS	VARCHAR2	(240)		PO comments
PO_RECEIVER_NOTE	VARCHAR2	(480)		PO Receiver Note
SUPPLIER_PROD_NUM	VARCHAR2	(25)		Supplier Product Number
SHP_CANCEL_REASON	VARCHAR2	(240)		shipment cancel reason
SHP_CLOSED_REASON	VARCHAR2	(240)		shipment closed reason
SHP_SRC_SHIP_ID	NUMBER			source shipment id
DISTRIBUTION_ID	NUMBER		Yes	PO Distribution Id
LINE_LOCATION_ID	NUMBER			Line Location id
PO_HEADER_ID	NUMBER		Yes	PO Header Id
PO_LINE_ID	NUMBER			PO Line Id
PO_RELEASE_ID	NUMBER			PO Release Id
SOURCE_DIST_ID	NUMBER			Source Distribution Id
REVISION_NUM	NUMBER			Revision Number
PO_NUMBER	VARCHAR2	(20)	Yes	PO Number
CONTRACT_NUM	VARCHAR2	(20)		Contract Number
RELEASE_NUM	NUMBER			Release Number
CCID	NUMBER			Code combination ID
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
COLLECTION_STATUS	VARCHAR2	(18)
_DF:PO_HDR:_EDW	CHAR	(21)		flexfield HDR
_DF:PO_LINES:_EDW	CHAR	(19)		flexfield lines
_DF:PO_POD:_EDW	CHAR	(27)		flexfield distribution
_DF:PO_PLL:_EDW	CHAR	(28)		flexfield shipment

Query Text

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


SELECT GLOBAL_CURRENCY_RATE
,      SEQ_ID
,      VIEW_ID
,      PO_DIST_INST_PK
,      SUPPLIER_ITEM_FK
,      INSTANCE_FK
,      PURCH_CLASS_FK
,      BUYER_FK
,      DELIVER_TO_FK
,      APPROVER_FK
,      ITEM_FK
,      SUPPLIER_SITE_FK
,      SHIP_TO_ORG_FK
,      DESTIN_ORG_FK
,      SOB_FK
,      SHIP_LOCATION_FK
,      BILL_LOCATION_FK
,      DELIV_LOCATION_FK
,      SUP_SITE_GEOG_FK
,      TASK_FK
,      PO_CREATE_DATE_FK
,      LNE_CREAT_DATE_FK
,      SHP_CREAT_DATE_FK
,      DST_CREAT_DATE_FK
,      PO_APP_DATE_FK
,      REVISED_DATE_FK
,      ACCPT_DUE_DATE_FK
,      RELEASE_DATE_FK
,      SHP_APP_DATE_FK
,      LST_ACCPT_DATE_FK
,      NEED_BY_DATE_FK
,      PROMISED_DATE_FK
,      PRINTED_DATE_FK
,      TXN_CUR_DATE_FK
,      REQ_CREAT_DATE_FK
,      REQ_APPRV_DATE_FK
,      PO_ACCEPT_DATE_FK
,      AP_TERMS_FK
,      SHIPMENT_TYPE_FK
,      SHIP_VIA_FK
,      FOB_FK
,      FREIGHT_TERMS_FK
,      TXN_REASON_FK
,      PRICE_TYPE_FK
,      PRICE_BREAK_FK
,      SHP_CLOSED_FK
,      DESTIN_TYPE_FK
,      CONTRACT_TYPE_FK
,      RCV_ROUTING_FK
,      ACCPT_REQUIRED_FK
,      FROZEN_FK
,      RELEASE_HOLD_FK
,      CONFIRM_ORDER_FK
,      NEG_BY_PREPARE_FK
,      SUB_RECEIPT_FK
,      SHP_APPROVED_FK
,      SHP_CANCELLED_FK
,      INSPECTION_REQ_FK
,      RECEIPT_REQ_FK
,      ACCRUED_FK
,      DST_ENCUMB_FK
,      ONLINE_REQ_FK
,      SHP_TAXABLE_FK
,      EDI_PROCESSED_FK
,      PCARD_PROCESS_FK
,      APPRV_SUPPLIER_FK
,      EDW_BASE_UOM_FK
,      EDW_UOM_FK
,      TXN_CUR_CODE_FK
,      PO_LINE_TYPE_FK
,      CHECK_CUT_DATE_FK
,      INV_RECEIVED_DATE_FK
,      INV_CREATION_DATE_FK
,      GOODS_RECEIVED_DATE_FK
,      DUNS_FK
,      UNSPSC_FK
,      SIC_CODE_FK
,      PO_CREATION_CYCLE_TIME
,      ORDER_TO_PAY_CYCLE_TIME
,      RECEIVE_TO_PAY_CYCL_TIME
,      INV_CREATION_CYCLE_TIME
,      INV_TO_PAY_CYCLE_TIME
,      IPV_T
,      IPV_G
,      AMT_PURCHASED_T
,      AMT_PURCHASED_G
,      AMT_CONTRACT_T
,      AMT_CONTRACT_G
,      AMT_NONCONTRACT_T
,      AMT_NONCONTRACT_G
,      AMT_LEAKAGE_T
,      AMT_LEAKAGE_G
,      POTENTIAL_SVG_T
,      POTENTIAL_SVG_G
,      AMT_BILLED_T
,      AMT_BILLED_G
,      QTY_BILLED_B
,      QTY_CANCELLED_B
,      QTY_DELIVERED_B
,      QTY_ORDERED_B
,      PRICE_T
,      PRICE_G
,      LIST_PRC_UNIT_T
,      LIST_PRC_UNIT_G
,      MARKET_PRICE_T
,      MARKET_PRICE_G
,      PRICE_LIMIT_T
,      PRICE_LIMIT_G
,      ITEM_ID
,      ITEM_DESCRIPTION
,      SUPPLIER_NOTE
,      LNE_SUPPLIER_NOTE
,      PO_COMMENTS
,      PO_RECEIVER_NOTE
,      SUPPLIER_PROD_NUM
,      SHP_CANCEL_REASON
,      SHP_CLOSED_REASON
,      SHP_SRC_SHIP_ID
,      DISTRIBUTION_ID
,      LINE_LOCATION_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_RELEASE_ID
,      SOURCE_DIST_ID
,      REVISION_NUM
,      PO_NUMBER
,      CONTRACT_NUM
,      RELEASE_NUM
,      CCID
,      LAST_UPDATE_DATE
,      COLLECTION_STATUS
,      _DF:PO_HDR:_EDW
,      _DF:PO_LINES:_EDW
,      _DF:PO_POD:_EDW
,      _DF:PO_PLL:_EDW
FROM APPS.POABV_EDW_PO_DISTRIBUTIONS_FCV;

Dependencies

[top of page]

APPS.POABV_EDW_PO_DISTRIBUTIONS_FCV references the following:

APPS: EDW_GEOGRAPHY_PKG - show dependent code; EDW_ITEMS_PKG - show dependent code; EDW_LOCAL_INSTANCE; EDW_UTIL - show dependent code; FINANCIALS_SYSTEM_PARAMS_ALL; GL_SETS_OF_BOOKS; HR_LOCATIONS_ALL; MTL_UNITS_OF_MEASURE; POA_BIS_SAVINGS; POA_EDW_PO_DIST_INC; POA_EDW_VARIABLES_PKG - show dependent code; POA_OLTP_GENERIC_PKG - show dependent code; PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES; PO_RELEASES_ALL; PO_REQ_DISTRIBUTIONS_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL; RCV_ROUTING_HEADERS

APPS.POABV_EDW_PO_DISTRIBUTIONS_FCV is referenced by following:

APPS: POA_EDW_PO_DISTRIBUTIONS_FCV