VIEW: APPS.CSL_CONTR_BUSS_TXN_TYPES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, B.INCIDENT_ID, B.TXN_BILLING_TYPE_ID, B.BUSINESS_PROCESS_ID, B.CONTRACT_SERVICE_ID, B.UP_TO_AMOUNT, B.PERCENT_COVERED FROM CSL_CONTR_BUSS_TXN_TYPES B , CSL_CONTR_BUSS_TXN_TYPES_ACC ACC WHERE B.TXN_BILLING_TYPE_ID = ACC.TXN_BILLING_TYPE_ID AND B.BUSINESS_PROCESS_ID = ACC.BUSINESS_PROCESS_ID AND B.INCIDENT_ID = ACC.INCIDENT_ID AND ACC.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.INCIDENT_ID
, B.TXN_BILLING_TYPE_ID
, B.BUSINESS_PROCESS_ID
, B.CONTRACT_SERVICE_ID
, B.UP_TO_AMOUNT
, B.PERCENT_COVERED
FROM CSL_CONTR_BUSS_TXN_TYPES B
, CSL_CONTR_BUSS_TXN_TYPES_ACC ACC
WHERE B.TXN_BILLING_TYPE_ID = ACC.TXN_BILLING_TYPE_ID
AND B.BUSINESS_PROCESS_ID = ACC.BUSINESS_PROCESS_ID
AND B.INCIDENT_ID = ACC.INCIDENT_ID
AND ACC.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID