View: CSD_FLOW_STATUS_RULES_V

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

View Text

SELECT FLWSTS_B.FLWSTS_TRAN_ID FLWSTS_TRAN_ID
, FLWSTS_B.REPAIR_TYPE_ID REPAIR_TYPE_ID
, FLWSTS_B.FROM_FLOW_STATUS_ID CURRENT_FLOW_STATUS_ID
, CURR_STS_LKUP.LOOKUP_CODE CURRENT_FLOW_STATUS_CODE
, CURR_STS_LKUP.MEANING CURRENT_FLOW_STATUS
, FLWSTS_B.TO_FLOW_STATUS_ID NEXT_FLOW_STATUS_ID
, NEXT_STS_LKUP.LOOKUP_CODE NEXT_FLOW_STATUS_CODE
, NEXT_STS_LKUP.MEANING NEXT_FLOW_STATUS
, FLWSTS_B.WF_ITEM_TYPE WF_ITEM_TYPE
, FLWSTS_B.WF_PROCESS_NAME WF_PROCESS_NAME
, WF_PROC.DISPLAY_NAME WF_DISPLAY_NAME
, FLWSTS_B.REASON_REQUIRED_FLAG REASON_REQUIRED_FLAG
, FLWSTS_B.CAPTURE_ACTIVITY_FLAG CAPTURE_ACTIVITY_FLAG
, FLWSTS_TL.DESCRIPTION DESCRIPTION
, FLWSTS_B.ALLOW_ALL_RESP_FLAG ALLOW_ALL_RESP_FLAG
, FLWSTS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM CSD_FLWSTS_TRANS_B FLWSTS_B
, CSD_FLWSTS_TRANS_TL FLWSTS_TL
, CSD_FLOW_STATUSES_B CURR_B
, CSD_FLOW_STATUSES_B NEXT_B
, FND_LOOKUPS CURR_STS_LKUP
, FND_LOOKUPS NEXT_STS_LKUP
, WF_RUNNABLE_PROCESSES_V WF_PROC
WHERE FLWSTS_TL.FLWSTS_TRAN_ID = FLWSTS_B.FLWSTS_TRAN_ID
AND FLWSTS_TL.LANGUAGE = USERENV('LANG')
AND CURR_B.FLOW_STATUS_ID = FLWSTS_B.FROM_FLOW_STATUS_ID
AND CURR_STS_LKUP.LOOKUP_TYPE = 'CSD_REPAIR_FLOW_STATUS'
AND CURR_STS_LKUP.LOOKUP_CODE = CURR_B.FLOW_STATUS_CODE
AND NEXT_B.FLOW_STATUS_ID = FLWSTS_B.TO_FLOW_STATUS_ID
AND NEXT_STS_LKUP.LOOKUP_TYPE = 'CSD_REPAIR_FLOW_STATUS'
AND NEXT_STS_LKUP.LOOKUP_CODE = NEXT_B.FLOW_STATUS_CODE
AND WF_PROC.ITEM_TYPE(+) = FLWSTS_B.WF_ITEM_TYPE
AND WF_PROC.PROCESS_NAME(+) = FLWSTS_B.WF_PROCESS_NAME

Columns