View: CSD_REPAIR_TYPES_SAR_VL

Product:	CSD - Depot Repair
Description:
Implementation/DBA Data:	APPS.CSD_REPAIR_TYPES_SAR_VL

View Text

SELECT DISTINCT CRTS.ROWID
, CRTS.REPAIR_TXN_BILLING_TYPE_ID
, CRTV.REPAIR_TYPE_ID
, CTBT.TXN_BILLING_TYPE_ID
, CTTV.TRANSACTION_TYPE_ID
, CTTV.NAME
, CTTV.DESCRIPTION
, CTBT.BILLING_TYPE
, FLV.MEANING
, FLV.DESCRIPTION
, CBTC.BILLING_CATEGORY
, FLV.LOOKUP_TYPE
, CTTV.DEPOT_REPAIR_FLAG
, CRTS.CREATED_BY
, CRTS.CREATION_DATE
, CRTS.LAST_UPDATED_BY
, CRTS.LAST_UPDATE_DATE
, CRTS.LAST_UPDATE_LOGIN
, CRTS.OBJECT_VERSION_NUMBER
FROM CS_TRANSACTION_TYPES_VL CTTV
, CS_TXN_BILLING_TYPES CTBT
, CS_BILLING_TYPE_CATEGORIES CBTC
, FND_LOOKUP_VALUES_VL FLV
, CSD_REPAIR_TYPES_SAR CRTS
, CSD_REPAIR_TYPES_VL CRTV
WHERE CTTV.TRANSACTION_TYPE_ID = CTBT.TRANSACTION_TYPE_ID
AND CBTC.BILLING_TYPE = CTBT.BILLING_TYPE
AND FLV.LOOKUP_CODE = CBTC.BILLING_TYPE
AND CTBT.TXN_BILLING_TYPE_ID = CRTS.TXN_BILLING_TYPE_ID
AND FLV.LOOKUP_TYPE = 'MTL_SERVICE_BILLABLE_FLAG'
AND CRTS.REPAIR_TYPE_ID = CRTV.REPAIR_TYPE_ID

Columns