VIEW: APPS.CSD_REPAIR_TYPES_SAR_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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