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

Source

View Text - Preformatted


SELECT acc.access_id, bpt.transaction_type_id, bpt.business_process_id, bpr.name from cs_bus_process_txns bpt, cs_business_processes bpr, csm_bus_process_txns_acc acc WHERE bpr.business_process_id = bpt.business_process_id and bpr.field_service_flag = 'Y' AND acc.business_process_id = bpt.business_process_id AND acc.transaction_type_id = bpt.transaction_type_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, BPT.TRANSACTION_TYPE_ID
, BPT.BUSINESS_PROCESS_ID
, BPR.NAME
FROM CS_BUS_PROCESS_TXNS BPT
, CS_BUSINESS_PROCESSES BPR
, CSM_BUS_PROCESS_TXNS_ACC ACC
WHERE BPR.BUSINESS_PROCESS_ID = BPT.BUSINESS_PROCESS_ID
AND BPR.FIELD_SERVICE_FLAG = 'Y'
AND ACC.BUSINESS_PROCESS_ID = BPT.BUSINESS_PROCESS_ID
AND ACC.TRANSACTION_TYPE_ID = BPT.TRANSACTION_TYPE_ID