View: CSD_REPAIR_TYPE_RULES_V

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

View Text

SELECT RT_TRAN_B.RT_TRAN_ID RT_TRAN_ID
, RT_TRAN_B.FROM_REPAIR_TYPE_ID FROM_REPAIR_TYPE_ID
, RT_TRAN_B.COMMON_FLOW_STATUS_ID COMMON_FLOW_STATUS_ID
, RT_TRAN_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, COMM_STS_LKUP.LOOKUP_CODE COMMON_FLOW_STATUS_CODE
, COMM_STS_LKUP.MEANING COMMON_FLOW_STATUS
, RT_TRAN_B.TO_REPAIR_TYPE_ID TO_REPAIR_TYPE_ID
, TO_RTYP_TL.NAME TO_REPAIR_TYPE
, RT_TRAN_B.REASON_REQUIRED_FLAG REASON_REQUIRED_FLAG
, RT_TRAN_B.CAPTURE_ACTIVITY_FLAG CAPTURE_ACTIVITY_FLAG
, RT_TRAN_B.ALLOW_ALL_RESP_FLAG ALLOW_ALL_RESP_FLAG
, RT_TRAN_TL.DESCRIPTION DESCRIPTION
FROM CSD_RT_TRANS_B RT_TRAN_B
, CSD_RT_TRANS_TL RT_TRAN_TL
, CSD_REPAIR_TYPES_TL TO_RTYP_TL
, CSD_FLOW_STATUSES_B COMM_B
, FND_LOOKUPS COMM_STS_LKUP
WHERE RT_TRAN_TL.RT_TRAN_ID = RT_TRAN_B.RT_TRAN_ID
AND RT_TRAN_TL.LANGUAGE = USERENV('LANG')
AND TO_RTYP_TL.REPAIR_TYPE_ID = RT_TRAN_B.TO_REPAIR_TYPE_ID
AND TO_RTYP_TL.LANGUAGE = USERENV('LANG')
AND COMM_B.FLOW_STATUS_ID = RT_TRAN_B.COMMON_FLOW_STATUS_ID
AND COMM_STS_LKUP.LOOKUP_TYPE = 'CSD_REPAIR_FLOW_STATUS'
AND COMM_STS_LKUP.LOOKUP_CODE = COMM_B.FLOW_STATUS_CODE

Columns