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

Object Details

Object Name:	CSI_BIS_TXN_DTLS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSI.CSI_BIS_TXN_DTLS_V
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
SOURCE_TRANSACTION_ID	NUMBER		Yes	Source Transaction ID (PK for the source transaction table above)
SOURCE_TRANSACTION_TABLE	VARCHAR2	(30)	Yes	Table name of the source application's table which integrates with the transaction details
SOURCE_TRANSACTION_TYPE_ID	NUMBER		Yes	Source Transaction Type ID seeded by IB for each source application & distinct business process
CS_TRANSACTION_TYPE_ID	NUMBER
IB_TRANSACTION_TYPE_ID	NUMBER		Yes
TRANSACTION_TYPE_NAME	VARCHAR2	(90)
TRANSACTION_TYPE_DESCRIPTION	VARCHAR2	(720)
SYSTEM_ID	NUMBER			FK to CSI_SYSTEMS_B
SYSTEM_NAME	VARCHAR2	(50)
SYSTEM_NUMBER	VARCHAR2	(30)
TXN_LINE_DETAIL_ID	NUMBER		Yes	Primary Key
INVENTORY_ITEM_ID	NUMBER			FK to MTL_SYSTEM_ITEMS
INV_ORGANIZATION_ID	NUMBER			Master INV Organization ID
INVENTORY_REVISION	VARCHAR2	(3)		FK to MTL_ITEM_REVISIONS
QUANTITY	NUMBER			Quantity
UNIT_OF_MEASURE	VARCHAR2	(3)		UOM Code
SERIAL_NUMBER	VARCHAR2	(30)		FK to MTL_SERIAL_NUMBERS
MFG_SERIAL_NUMBER_FLAG	VARCHAR2	(1)		Is the Serial Number the Manufacturer's?
LOT_NUMBER	VARCHAR2	(80)		FK to MTL_LOT_NUMBERS
INSTANCE_ID	NUMBER			FK to CSI_ITEM_INSTANCES
INSTANCE_TYPE_CODE	VARCHAR2	(30)		Instance Type - CSI Lookup
LOCATION_TYPE_CODE	VARCHAR2	(30)		Installation Location Type - HZ_PARTY_SITES
LOCATION_ID	NUMBER			Installation Location - HZ PARTY_SITE_ID
INSTALLATION_DATE	DATE			Installation Date
PROCESSING_STATUS	VARCHAR2	(30)		Status of the Set of Transaction Line Details entered for the source Line.
ERROR_CODE	VARCHAR2	(240)		error code - if the transaction fails in the interface process
ERROR_EXPLANATION	VARCHAR2	(240)		error explanation - if the transaction fails in the interface process
SOURCE_TXN_LINE_DETAIL_ID	NUMBER			Parent Txn Line detail ID, if any - FK to CSI_T_TXN_LINE_DETAILS

Query Text

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


SELECT SOURCE_TRANSACTION_ID
,      SOURCE_TRANSACTION_TABLE
,      SOURCE_TRANSACTION_TYPE_ID
,      CS_TRANSACTION_TYPE_ID
,      IB_TRANSACTION_TYPE_ID
,      TRANSACTION_TYPE_NAME
,      TRANSACTION_TYPE_DESCRIPTION
,      SYSTEM_ID
,      SYSTEM_NAME
,      SYSTEM_NUMBER
,      TXN_LINE_DETAIL_ID
,      INVENTORY_ITEM_ID
,      INV_ORGANIZATION_ID
,      INVENTORY_REVISION
,      QUANTITY
,      UNIT_OF_MEASURE
,      SERIAL_NUMBER
,      MFG_SERIAL_NUMBER_FLAG
,      LOT_NUMBER
,      INSTANCE_ID
,      INSTANCE_TYPE_CODE
,      LOCATION_TYPE_CODE
,      LOCATION_ID
,      INSTALLATION_DATE
,      PROCESSING_STATUS
,      ERROR_CODE
,      ERROR_EXPLANATION
,      SOURCE_TXN_LINE_DETAIL_ID
FROM APPS.CSI_BIS_TXN_DTLS_V;

Dependencies

[top of page]

APPS.CSI_BIS_TXN_DTLS_V references the following:

APPS: CSI_SYSTEMS_VL; CSI_TXN_SUB_TYPES; CSI_T_TRANSACTION_LINES; CSI_T_TXN_LINE_DETAILS

APPS.CSI_BIS_TXN_DTLS_V is not referenced by any database object