View: CSF_DEBRIEF_TRANS_TYPES_V

Product:	CSF - Field Service
Description:	Lists debrief transaction types
Implementation/DBA Data:	APPS.CSF_DEBRIEF_TRANS_TYPES_V

View Text

SELECT CTTV.TRANSACTION_TYPE_ID
, CTTV.NAME
, CBP.BUSINESS_PROCESS_ID
, CTTV.LINE_ORDER_CATEGORY_CODE
FROM CS_TRANSACTION_TYPES_VL CTTV
, CS_TXN_BILLING_TYPES CTBT
, CS_BUS_PROCESS_TXNS CBPT
, CS_BUSINESS_PROCESSES CBP
, CSI_TXN_SUB_TYPES CTST
, CSI_TXN_TYPES CTT
, CSI_INSTANCE_STATUSES CIS
, CS_BILLING_TYPE_CATEGORIES CBTC
WHERE CTTV.TRANSACTION_TYPE_ID = CTBT.TRANSACTION_TYPE_ID
AND CTBT.TRANSACTION_TYPE_ID = CBPT.TRANSACTION_TYPE_ID
AND TRUNC(SYSDATE) BETWEEN NVL(CTBT.START_DATE_ACTIVE
, TO_DATE(SYSDATE
, 'DD/MM/RRRR'))
AND NVL(CTBT.END_DATE_ACTIVE
, TO_DATE(SYSDATE
, 'DD/MM/RRRR'))
AND TRUNC(SYSDATE) BETWEEN NVL(CBPT.START_DATE_ACTIVE
, TO_DATE(SYSDATE
, 'DD/MM/RRRR'))
AND NVL(CBPT.END_DATE_ACTIVE
, TO_DATE(SYSDATE
, 'DD/MM/RRRR'))
AND CBPT.BUSINESS_PROCESS_ID = CBP.BUSINESS_PROCESS_ID
AND CBP.FIELD_SERVICE_FLAG = 'Y'
AND CTBT.BILLING_TYPE = CBTC.BILLING_TYPE
AND CBTC.BILLING_CATEGORY = 'M'
AND CTST.CS_TRANSACTION_TYPE_ID = CTTV.TRANSACTION_TYPE_ID
AND CTT.SOURCE_APPLICATION_ID=513
AND CTT.TRANSACTION_TYPE_ID = CTST.TRANSACTION_TYPE_ID
AND CTST.SRC_STATUS_ID = CIS.INSTANCE_STATUS_ID(+)
AND (( CTST.UPDATE_IB_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(CIS.START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(CIS.END_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(CIS.TERMINATED_FLAG
, 'N') <> 'Y'
AND CTST.SRC_CHANGE_OWNER = 'Y'
AND NVL(CTST.SRC_RETURN_REQD
, 'N') = 'N'
AND ( (CTST.SRC_CHANGE_OWNER_TO_CODE = 'I'
AND NVL(CTST.PARENT_REFERENCE_REQD
, 'N') = 'N'
AND CTTV.LINE_ORDER_CATEGORY_CODE='RETURN') OR (CTST.SRC_CHANGE_OWNER_TO_CODE = 'E'
AND CTST.SRC_REFERENCE_REQD = 'Y'
AND CTTV.LINE_ORDER_CATEGORY_CODE='ORDER') ) ) ) ORDER BY CTTV.NAME

Columns