View: CSI_BIS_TXN_DTLS_V

Product:	CSI - Install Base
Description:	View created for the Oracle IT - GSI
Implementation/DBA Data:	APPS.CSI_BIS_TXN_DTLS_V

View Text

SELECT TL.SOURCE_TRANSACTION_ID
, TL.SOURCE_TRANSACTION_TABLE
, TL.SOURCE_TRANSACTION_TYPE_ID
, IBTXN.CS_TRANSACTION_TYPE_ID CS_TRANSACTION_TYPE_ID
, TLD.SUB_TYPE_ID IB_TRANSACTION_TYPE_ID
, IBTXN.NAME TRANSACTION_TYPE_NAME
, IBTXN.DESCRIPTION TRANSACTION_TYPE_DESCRIPTION
, TLD.CSI_SYSTEM_ID SYSTEM_ID
, SYS.NAME SYSTEM_NAME
, SYS.SYSTEM_NUMBER
, TLD.TXN_LINE_DETAIL_ID
, TLD.INVENTORY_ITEM_ID
, TLD.INV_ORGANIZATION_ID
, TLD.INVENTORY_REVISION
, TLD.QUANTITY
, TLD.UNIT_OF_MEASURE
, TLD.SERIAL_NUMBER
, TLD.MFG_SERIAL_NUMBER_FLAG
, TLD.LOT_NUMBER
, TLD.INSTANCE_ID
, TLD.INSTANCE_TYPE_CODE
, TLD.LOCATION_TYPE_CODE
, TLD.LOCATION_ID
, TLD.INSTALLATION_DATE
, TLD.PROCESSING_STATUS
, TLD.ERROR_CODE
, TLD.ERROR_EXPLANATION
, TLD.SOURCE_TXN_LINE_DETAIL_ID
FROM CSI_T_TXN_LINE_DETAILS TLD
, CSI_T_TRANSACTION_LINES TL
, CSI_SYSTEMS_VL SYS
, CSI_TXN_SUB_TYPES IBTXN
WHERE TLD.TRANSACTION_LINE_ID = TL.TRANSACTION_LINE_ID
AND IBTXN.TRANSACTION_TYPE_ID = TL.SOURCE_TRANSACTION_TYPE_ID
AND IBTXN.SUB_TYPE_ID = TLD.SUB_TYPE_ID
AND TLD.CSI_SYSTEM_ID = SYS.SYSTEM_ID (+)

Columns