Product: | JTF - CRM Foundation |
---|---|
Description: | View used for the business rule workbench form. |
Implementation/DBA Data: | APPS.JTF_BRM_RULES_V |
SELECT JOL.ROW_ID ROW_ID
, JOL.RULE_ID
, JOL.RULE_NAME
, JOL.RULE_DESCRIPTION
, JOL.RULE_OWNER RULE_OWNER_ID
, PAP.FULL_NAME RULE_OWNER_NAME
, JOL.BRM_OBJECT_TYPE
, JOL.BRM_OBJECT_CODE
, FL1.MEANING OBJECT
, JBS.PROCESS_ID
, JBS.BRM_CHECK_INTERVAL
, JBS.BRM_UOM_TYPE
, JBS.BRM_CHECK_UOM_CODE
, FL2.MEANING CHECK_INTERVAL_UOM
, JBS.BRM_TOLERANCE_INTERVAL
, JBS.BRM_TOLERANCE_UOM_CODE
, FL3.MEANING TOLERANCE_INTERVAL_UOM
, JOL.START_DATE_ACTIVE RULE_START_DATE_ACTIVE
, JOL.END_DATE_ACTIVE RULE_END_DATE_ACTIVE
, JBS.WORKFLOW_ITEM_TYPE
, JBS.WORKFLOW_PROCESS_NAME
, WFL.WF_DESCRIPTION WORKFLOW_DISPLAY_NAME
, JBS.SEEDED_FLAG
, JOL.VIEW_NAME
, JOL.VIEW_DEFINITION
, JBS.START_DATE_ACTIVE PROCESS_START_DATE_ACTIVE
, JBS.END_DATE_ACTIVE PROCESS_END_DATE_ACTIVE
, JOL.ATTRIBUTE1
, JOL.ATTRIBUTE2
, JOL.ATTRIBUTE3
, JOL.ATTRIBUTE4
, JOL.ATTRIBUTE5
, JOL.ATTRIBUTE6
, JOL.ATTRIBUTE7
, JOL.ATTRIBUTE8
, JOL.ATTRIBUTE9
, JOL.ATTRIBUTE10
, JOL.ATTRIBUTE11
, JOL.ATTRIBUTE12
, JOL.ATTRIBUTE13
, JOL.ATTRIBUTE14
, JOL.ATTRIBUTE15
, JOL.ATTRIBUTE_CATEGORY
FROM JTF_BRM_RULES_VL JOL
, JTF_BRM_PROCESSES JBS
, (SELECT FND.LOOKUP_TYPE
, FND.LOOKUP_CODE
, FND.MEANING
, FND.DESCRIPTION
, FND.ENABLED_FLAG
, FND.START_DATE_ACTIVE
, FND.END_DATE_ACTIVE
FROM FND_LOOKUPS FND
WHERE FND.LOOKUP_TYPE = 'JTF_BRM_OBJECT_TYPE'
AND FND.ENABLED_FLAG = 'Y'
AND (FND.START_DATE_ACTIVE <= TRUNC(SYSDATE) OR FND.START_DATE_ACTIVE IS NULL)
AND (FND.END_DATE_ACTIVE > TRUNC(SYSDATE) OR FND.END_DATE_ACTIVE IS NULL) ) FL1
, (SELECT FND.LOOKUP_TYPE
, FND.LOOKUP_CODE
, FND.MEANING
, FND.DESCRIPTION
, FND.ENABLED_FLAG
, FND.START_DATE_ACTIVE
, FND.END_DATE_ACTIVE
FROM FND_LOOKUPS FND
WHERE FND.LOOKUP_TYPE = 'JTF_BRM_UOM_TYPE'
AND FND.ENABLED_FLAG = 'Y'
AND (FND.START_DATE_ACTIVE <= TRUNC(SYSDATE) OR FND.START_DATE_ACTIVE IS NULL)
AND (FND.END_DATE_ACTIVE > TRUNC(SYSDATE) OR FND.END_DATE_ACTIVE IS NULL) ) FL2
, (SELECT FND.LOOKUP_TYPE
, FND.LOOKUP_CODE
, FND.MEANING
, FND.DESCRIPTION
, FND.ENABLED_FLAG
, FND.START_DATE_ACTIVE
, FND.END_DATE_ACTIVE
FROM FND_LOOKUPS FND
WHERE FND.LOOKUP_TYPE = 'JTF_BRM_UOM_TYPE'
AND FND.ENABLED_FLAG = 'Y'
AND (FND.START_DATE_ACTIVE <= TRUNC(SYSDATE) OR FND.START_DATE_ACTIVE IS NULL)
AND (FND.END_DATE_ACTIVE > TRUNC(SYSDATE) OR FND.END_DATE_ACTIVE IS NULL) ) FL3
, ( SELECT PERSON_ID
, FULL_NAME
FROM PER_ALL_PEOPLE_F
WHERE EFFECTIVE_END_DATE > SYSDATE ) PAP
, JTF_LOOKUPS_BRM_WF_V WFL
WHERE JOL.RULE_ID = JBS.RULE_ID(+)
AND JOL.BRM_OBJECT_TYPE = FL1.LOOKUP_TYPE(+)
AND JBS.BRM_UOM_TYPE = FL2.LOOKUP_TYPE(+)
AND JBS.BRM_UOM_TYPE = FL3.LOOKUP_TYPE(+)
AND JOL.BRM_OBJECT_CODE = FL1.LOOKUP_CODE(+)
AND JBS.BRM_CHECK_UOM_CODE = FL2.LOOKUP_CODE(+)
AND JBS.BRM_TOLERANCE_UOM_CODE = FL3.LOOKUP_CODE(+)
AND JOL.RULE_OWNER = PAP.PERSON_ID(+)
AND JBS.WORKFLOW_ITEM_TYPE = WFL.WF_ITEM_TYPE(+)
AND JBS.WORKFLOW_PROCESS_NAME = WFL.WF_PROCESS_NAME(+)