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_RECEIVING_TXN_FCV

Object Details

Object Name:	POABV_EDW_RECEIVING_TXN_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POABV_EDW_RECEIVING_TXN_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 Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SEQ_ID	NUMBER
VIEW_ID	NUMBER
RCV_TXN_PK	VARCHAR2	(71)
INSTANCE_FK	VARCHAR2	(30)
TXN_TYPE_FK	VARCHAR2	(49)
ITEM_REVISION_FK	VARCHAR2	(4000)
PO_LINE_TYPE_FK	VARCHAR2	(25)	Yes
EDW_BASE_UOM_FK	VARCHAR2	(4000)
EDW_UOM_FK	VARCHAR2	(4000)
RECEIPT_SOURCE_FK	VARCHAR2	(49)
SUPPLIER_SITE_FK	VARCHAR2	(4000)
SUP_SITE_GEOG_FK	VARCHAR2	(223)
DESTIN_TYPE_FK	VARCHAR2	(49)
RCV_DEL_TO_ORG_FK	VARCHAR2	(4000)
RCV_LOCATION_FK	VARCHAR2	(4000)
DELIV_LOCATION_FK	VARCHAR2	(4000)
LOCATOR_FK	VARCHAR2	(4000)
BUYER_FK	VARCHAR2	(4000)
DELIVER_TO_FK	VARCHAR2	(4000)
TXN_DATE_FK	VARCHAR2	(4000)
TXN_CREAT_FK	VARCHAR2	(4000)
SHIPPED_TO_DATE_FK	VARCHAR2	(4000)
EXPCT_RCV_DATE_FK	VARCHAR2	(4000)
PROMISED_DATE_FK	VARCHAR2	(4000)
NEED_BY_DATE_FK	VARCHAR2	(4000)
LST_ACCPT_DATE_FK	VARCHAR2	(4000)
SRC_CREAT_DATE_FK	VARCHAR2	(4000)
PARNT_TXN_DATE_FK	VARCHAR2	(4000)
AP_TERMS_FK	VARCHAR2	(73)
RCV_ROUTING_FK	VARCHAR2	(96)
SUBST_UNORD_FK	VARCHAR2	(50)
PARNT_TXN_TYPE_FK	VARCHAR2	(49)
FREIGHT_TERMS_FK	VARCHAR2	(43)
INSPECT_STATUS_FK	VARCHAR2	(46)
INSPECT_QUAL_FK	VARCHAR2	(45)
RECEIVE_EXCEP_FK	VARCHAR2	(12)
USER_ENTERED_FK	VARCHAR2	(12)
TXN_REASON_FK	VARCHAR2	(45)
TXN_CUR_CODE_FK	VARCHAR2	(15)
PURCHASE_CLASS_CODE_FK	VARCHAR2	(4000)
SUPPLIER_ITEM_NUM_FK	VARCHAR2	(4000)
QTY_TXN	VARCHAR2	(40)
QTY_TXN_NET	VARCHAR2	(40)
QTY_RECEIVED	VARCHAR2	(40)
QTY_ACCEPT	VARCHAR2	(40)
QTY_REJECT	VARCHAR2	(40)
QTY_RETURN_TO_VENDOR	VARCHAR2	(40)
QTY_RETURN_TO_RECEIVING	VARCHAR2	(40)
QTY_DELIVER	VARCHAR2	(40)
QTY_TRANSFER	VARCHAR2	(40)
PRICE_T	NUMBER
PRICE_G	NUMBER
NUM_DAYS_TO_FULL_DEL	NUMBER
SHIPMENT_NUM	VARCHAR2	(30)
INVOICE_NUM	VARCHAR2	(50)
RECEIPT_NUM_INST	VARCHAR2	(71)
SOURCE_TXN_NUMBER	VARCHAR2	(20)	Yes
VENDOR_LOT_NUM	VARCHAR2	(30)
RMA_REFERENCE	VARCHAR2	(30)
TXN_COMMENTS	VARCHAR2	(240)
SHIP_HDR_COMMENTS	VARCHAR2	(4000)
WAY_AIRBILL_NUM	VARCHAR2	(20)
BILL_OF_LADING	VARCHAR2	(25)
PACKING_SLIP	VARCHAR2	(25)
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
DUNS_FK	VARCHAR2	(0)
UNSPSC_FK	VARCHAR2	(0)
SIC_CODE_FK	VARCHAR2	(0)
PO_DISTRIBUTION_ID	NUMBER			rcv.po_distribution_id
_DF:PO_HDR:_EDW	CHAR	(21)
_DF:PO_LINES:_EDW	CHAR	(19)
_DF:PO_RCV:_EDW	CHAR	(29)

Query Text

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


SELECT SEQ_ID
,      VIEW_ID
,      RCV_TXN_PK
,      INSTANCE_FK
,      TXN_TYPE_FK
,      ITEM_REVISION_FK
,      PO_LINE_TYPE_FK
,      EDW_BASE_UOM_FK
,      EDW_UOM_FK
,      RECEIPT_SOURCE_FK
,      SUPPLIER_SITE_FK
,      SUP_SITE_GEOG_FK
,      DESTIN_TYPE_FK
,      RCV_DEL_TO_ORG_FK
,      RCV_LOCATION_FK
,      DELIV_LOCATION_FK
,      LOCATOR_FK
,      BUYER_FK
,      DELIVER_TO_FK
,      TXN_DATE_FK
,      TXN_CREAT_FK
,      SHIPPED_TO_DATE_FK
,      EXPCT_RCV_DATE_FK
,      PROMISED_DATE_FK
,      NEED_BY_DATE_FK
,      LST_ACCPT_DATE_FK
,      SRC_CREAT_DATE_FK
,      PARNT_TXN_DATE_FK
,      AP_TERMS_FK
,      RCV_ROUTING_FK
,      SUBST_UNORD_FK
,      PARNT_TXN_TYPE_FK
,      FREIGHT_TERMS_FK
,      INSPECT_STATUS_FK
,      INSPECT_QUAL_FK
,      RECEIVE_EXCEP_FK
,      USER_ENTERED_FK
,      TXN_REASON_FK
,      TXN_CUR_CODE_FK
,      PURCHASE_CLASS_CODE_FK
,      SUPPLIER_ITEM_NUM_FK
,      QTY_TXN
,      QTY_TXN_NET
,      QTY_RECEIVED
,      QTY_ACCEPT
,      QTY_REJECT
,      QTY_RETURN_TO_VENDOR
,      QTY_RETURN_TO_RECEIVING
,      QTY_DELIVER
,      QTY_TRANSFER
,      PRICE_T
,      PRICE_G
,      NUM_DAYS_TO_FULL_DEL
,      SHIPMENT_NUM
,      INVOICE_NUM
,      RECEIPT_NUM_INST
,      SOURCE_TXN_NUMBER
,      VENDOR_LOT_NUM
,      RMA_REFERENCE
,      TXN_COMMENTS
,      SHIP_HDR_COMMENTS
,      WAY_AIRBILL_NUM
,      BILL_OF_LADING
,      PACKING_SLIP
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      DUNS_FK
,      UNSPSC_FK
,      SIC_CODE_FK
,      PO_DISTRIBUTION_ID
,      _DF:PO_HDR:_EDW
,      _DF:PO_LINES:_EDW
,      _DF:PO_RCV:_EDW
FROM APPS.POABV_EDW_RECEIVING_TXN_FCV;

Dependencies

[top of page]

APPS.POABV_EDW_RECEIVING_TXN_FCV references the following:

APPS: AP_INVOICES_ALL; 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_LOOKUP_PKG - show dependent code; EDW_MTL_INVENTORY_LOC_PKG - show dependent code; 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_ITEM_LOCATIONS; MTL_TRANSACTION_REASONS; MTL_UNITS_OF_MEASURE; POA_CUSTOMIZATION_PKG - show dependent code; POA_EDW_RCV_TXNS_INC; POA_EDW_RCV_TXNS_PKG - show dependent code; PO_DOC_STYLE_HEADERS; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES; PO_VENDORS; PO_VENDOR_SITES_ALL; RCV_ROUTING_HEADERS; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS

APPS.POABV_EDW_RECEIVING_TXN_FCV is referenced by following:

APPS: POA_EDW_RECEIVING_TXN_FCV