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]

TABLE: POA.POA_DBI_RTX_F

Object Details

Object Name:	POA_DBI_RTX_F
Object Type:	TABLE
Owner:	POA
Subobject Name:
Status:	VALID

RCV Transactions base table - update and insert only

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POA_DBI_RTX_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	TRANSACTION_ID
POA_DBI_RTX_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	OE_ORDER_LINE_ID
POA_DBI_RTX_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	REQUISITION_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	RCV Transaction Id
TRANSACTION_TYPE	VARCHAR2	(25)	Yes	Transaction Type
PARENT_TRANSACTION_TYPE	VARCHAR2	(25)		Parent transaction type
GRP_TXN_DATE	DATE			Grouping Transaction Date
RECEIVE_TXN_DATE	DATE			Receiving transaction Date
SUPPLIER_ID	NUMBER			Supplier Id
SUPPLIER_SITE_ID	NUMBER			Supplier Site Id
BUYER_ID	NUMBER
CREATION_OPERATING_UNIT_ID	NUMBER			Creation Operating Unit Id
RECEIVING_ORG_ID	NUMBER			Receiving Organization Id
CATEGORY_ID	NUMBER
PO_ITEM_ID	NUMBER
REASON_ID	NUMBER			Reason Id
TRANSACTION_DATE	DATE		Yes	RCV Transaction Date
RCV_CREATION_DATE	DATE		Yes	RCV Creation Date
QUANTITY	NUMBER			Quantity in reporting UOM
QTY_AFTERDUE	NUMBER
QTY_BEFOREDUE	NUMBER
QTY_INTOL	NUMBER
BASE_UOM	VARCHAR2	(25)
AMOUNT_B	NUMBER
AMT_AFTERDUE_B	NUMBER
AMT_BEFOREDUE_B	NUMBER
EXPECTED_DATE	DATE
NUM_DAYS_LATE	NUMBER
NUM_DAYS_EARLY	NUMBER
FUNC_CUR_CODE	VARCHAR2	(15)		Functional Currency Code
GLOBAL_CUR_CONV_RATE	NUMBER			Global currency conversion rate, from functional currency
LINE_LOCATION_ID	NUMBER			PO Line Location Id
SHIPMENT_HEADER_ID	NUMBER		Yes	Shipment Header Id
SHIPMENT_LINE_ID	NUMBER		Yes	Shipment LIne Id
ASN_TYPE	VARCHAR2	(25)		ASN Type
RECEIPT_NUM	VARCHAR2	(30)		Receipt Number
CREATED_BY	NUMBER		Yes	Created By
LAST_UPDATE_LOGIN	NUMBER			Last Update Login
CREATION_DATE	DATE		Yes	Creation Date
LAST_UPDATED_BY	NUMBER		Yes	Last Updated By
LAST_UPDATE_DATE	DATE		Yes	Last Updated Date
SGLOBAL_CUR_CONV_RATE	NUMBER			Conversion Rate from Functional Currency to Secondary Global Currency
SOURCE_DOC_QUANTITY	NUMBER			Source Document Quantity
RECEIPT_EXISTS	VARCHAR2	(1)		Flag to check if Receipt Exists
CURRENCY_CONVERSION_RATE	NUMBER			Currency Conversion Rate
CURRENCY_CONVERSION_DATE	DATE			Currency Conversion Date
SOURCE_DOCUMENT_CODE	VARCHAR2	(25)		Source Document Code
SHIPPING_CONTROL	VARCHAR2	(30)		Shipping Control Flag
OE_ORDER_LINE_ID	NUMBER			Sales Order Line Id
REQUISITION_LINE_ID	NUMBER			Requisition Line Id
ROUTING_HEADER_ID	NUMBER			Routing Header Id
INVENTORY_ITEM_ID	NUMBER			Inventory Item Id
PRIMARY_QUANTITY	NUMBER			Primary Quantity
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary UOM Code
WMS_ENABLED_FLAG	VARCHAR2	(1)		WMS Enabled Flag
WMS_GRP_TXN_DATE	DATE			WMS Group Transaction Date
DROPSHIP_TYPE_CODE	NUMBER			Dropship Type Code
INV_TRANSACTION_ID	NUMBER			Inventory Transaction Id

Query Text

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


SELECT TRANSACTION_ID
,      TRANSACTION_TYPE
,      PARENT_TRANSACTION_TYPE
,      GRP_TXN_DATE
,      RECEIVE_TXN_DATE
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      BUYER_ID
,      CREATION_OPERATING_UNIT_ID
,      RECEIVING_ORG_ID
,      CATEGORY_ID
,      PO_ITEM_ID
,      REASON_ID
,      TRANSACTION_DATE
,      RCV_CREATION_DATE
,      QUANTITY
,      QTY_AFTERDUE
,      QTY_BEFOREDUE
,      QTY_INTOL
,      BASE_UOM
,      AMOUNT_B
,      AMT_AFTERDUE_B
,      AMT_BEFOREDUE_B
,      EXPECTED_DATE
,      NUM_DAYS_LATE
,      NUM_DAYS_EARLY
,      FUNC_CUR_CODE
,      GLOBAL_CUR_CONV_RATE
,      LINE_LOCATION_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      ASN_TYPE
,      RECEIPT_NUM
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      SGLOBAL_CUR_CONV_RATE
,      SOURCE_DOC_QUANTITY
,      RECEIPT_EXISTS
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      SOURCE_DOCUMENT_CODE
,      SHIPPING_CONTROL
,      OE_ORDER_LINE_ID
,      REQUISITION_LINE_ID
,      ROUTING_HEADER_ID
,      INVENTORY_ITEM_ID
,      PRIMARY_QUANTITY
,      PRIMARY_UOM_CODE
,      WMS_ENABLED_FLAG
,      WMS_GRP_TXN_DATE
,      DROPSHIP_TYPE_CODE
,      INV_TRANSACTION_ID
FROM POA.POA_DBI_RTX_F;

Dependencies

[top of page]

POA.POA_DBI_RTX_F does not reference any database object

POA.POA_DBI_RTX_F is referenced by following:

APPS: OPI_WMS_002_MV; POA_DBI_RTX_F; POA_RTX_BS_J_MV