VIEW: APPS.JTF_BRM_RULES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)