VIEW: APPS.JTF_BRM_PARAMETERS_V

Source

View Text - Preformatted

SELECT jbp.ROWID row_id , jbp.parameter_id , jbp.created_by , jbp.creation_date , jbp.last_updated_by , jbp.last_update_login , jbp.brm_uom_type , jbp.brm_uom_code , fl1.meaning brm_uom_meaning , jbp.brm_interval , jbp.brm_wf_command_type , jbp.brm_wf_command_code , fl2.meaning brm_wf_command_meaning , jbp.workflow_process_id , jbp.workflow_item_type , jbp.workflow_process_name FROM jtf_brm_parameters jbp , (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 <= SYSDATE OR fnd.start_date_active IS NULL) AND (fnd.end_date_active > 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_WF_COMMAND_TYPE' AND fnd.enabled_flag = 'Y' AND (fnd.start_date_active <= SYSDATE OR fnd.start_date_active IS NULL) AND (fnd.end_date_active > SYSDATE OR fnd.end_date_active IS NULL) ) fl2 WHERE jbp.brm_uom_type = fl1.lookup_type(+) AND jbp.brm_uom_code = fl1.lookup_code(+) AND jbp.brm_wf_command_type = fl2.lookup_type(+) AND jbp.brm_wf_command_code = fl2.lookup_code(+)

View Text - HTML Formatted

SELECT JBP.ROWID ROW_ID
, JBP.PARAMETER_ID
, JBP.CREATED_BY
, JBP.CREATION_DATE
, JBP.LAST_UPDATED_BY
, JBP.LAST_UPDATE_LOGIN
, JBP.BRM_UOM_TYPE
, JBP.BRM_UOM_CODE
, FL1.MEANING BRM_UOM_MEANING
, JBP.BRM_INTERVAL
, JBP.BRM_WF_COMMAND_TYPE
, JBP.BRM_WF_COMMAND_CODE
, FL2.MEANING BRM_WF_COMMAND_MEANING
, JBP.WORKFLOW_PROCESS_ID
, JBP.WORKFLOW_ITEM_TYPE
, JBP.WORKFLOW_PROCESS_NAME
FROM JTF_BRM_PARAMETERS JBP
, (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 <= SYSDATE OR FND.START_DATE_ACTIVE IS NULL)
AND (FND.END_DATE_ACTIVE > 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_WF_COMMAND_TYPE'
AND FND.ENABLED_FLAG = 'Y'
AND (FND.START_DATE_ACTIVE <= SYSDATE OR FND.START_DATE_ACTIVE IS NULL)
AND (FND.END_DATE_ACTIVE > SYSDATE OR FND.END_DATE_ACTIVE IS NULL) ) FL2
WHERE JBP.BRM_UOM_TYPE = FL1.LOOKUP_TYPE(+)
AND JBP.BRM_UOM_CODE = FL1.LOOKUP_CODE(+)
AND JBP.BRM_WF_COMMAND_TYPE = FL2.LOOKUP_TYPE(+)
AND JBP.BRM_WF_COMMAND_CODE = FL2.LOOKUP_CODE(+)