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.

VIEW: APPS.CSI_BIS_TXN_DTLS_V

Source

View Text - Preformatted


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 (+)

View Text - HTML Formatted

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 (+)