VIEW: APPS.BOM_DEPARTMENT_RESOURCES_V

Source

View Text - Preformatted

SELECT BDR.ROWID ROW_ID , BDR.DEPARTMENT_ID , BDR.RESOURCE_ID , BR.RESOURCE_CODE , BR.DESCRIPTION RESOURCE_DESCRIPTION , BDR.LAST_UPDATE_DATE , BDR.LAST_UPDATED_BY , BDR.CREATION_DATE , BDR.CREATED_BY , BDR.LAST_UPDATE_LOGIN , BR.UNIT_OF_MEASURE UNIT_OF_MEASURE , BDR.SHARE_CAPACITY_FLAG , BDR.SHARE_FROM_DEPT_ID , BD.DEPARTMENT_CODE SHARE_FROM_DEPARTMENT , BD.DESCRIPTION DEPARTMENT_DESCRIPTION , DECODE(bdr.share_from_dept_id, NULL, BDR.CAPACITY_UNITS, BDR1.capacity_units) , BDR.RESOURCE_GROUP_NAME , BDR.AVAILABLE_24_HOURS_FLAG , BDR.ATTRIBUTE_CATEGORY , BDR.ATTRIBUTE1 , BDR.ATTRIBUTE2 , BDR.ATTRIBUTE3 , BDR.ATTRIBUTE4 , BDR.ATTRIBUTE5 , BDR.ATTRIBUTE6 , BDR.ATTRIBUTE7 , BDR.ATTRIBUTE8 , BDR.ATTRIBUTE9 , BDR.ATTRIBUTE10 , BDR.ATTRIBUTE11 , BDR.ATTRIBUTE12 , BDR.ATTRIBUTE13 , BDR.ATTRIBUTE14 , BDR.ATTRIBUTE15 , BDR.REQUEST_ID , BDR.PROGRAM_APPLICATION_ID , BDR.PROGRAM_ID , BDR.PROGRAM_UPDATE_DATE , bd.department_code , bd.disable_date ,br.disable_date ,br.organization_id ,bdr.exception_set_name ,DECODE(bdr.share_from_dept_id, null, bdr.ctp_flag, bdr1.ctp_flag) , bdr.atp_rule_id ,atp.rule_name ,BDR.UTILIZATION*100 ,BDR.EFFICIENCY*100 ,BDR.SCHEDULE_TO_INSTANCE ,BDR.SEQUENCING_WINDOW ,BDR.IDLE_TIME_TOLERANCE FROM mtl_atp_rules atp , BOM_DEPARTMENT_RESOURCES BDR , bom_department_resources bdr1 , BOM_RESOURCES BR , BOM_DEPARTMENTS BD WHERE BDR.RESOURCE_ID = BR.RESOURCE_ID AND BDR.SHARE_FROM_DEPT_ID = BD.DEPARTMENT_ID(+) and bdr.share_from_dept_id = bdr1.department_id (+) and bdr.resource_id = bdr1.resource_id (+) and bdr.atp_rule_id = atp.rule_id (+)

View Text - HTML Formatted

SELECT BDR.ROWID ROW_ID
, BDR.DEPARTMENT_ID
, BDR.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.DESCRIPTION RESOURCE_DESCRIPTION
, BDR.LAST_UPDATE_DATE
, BDR.LAST_UPDATED_BY
, BDR.CREATION_DATE
, BDR.CREATED_BY
, BDR.LAST_UPDATE_LOGIN
, BR.UNIT_OF_MEASURE UNIT_OF_MEASURE
, BDR.SHARE_CAPACITY_FLAG
, BDR.SHARE_FROM_DEPT_ID
, BD.DEPARTMENT_CODE SHARE_FROM_DEPARTMENT
, BD.DESCRIPTION DEPARTMENT_DESCRIPTION
, DECODE(BDR.SHARE_FROM_DEPT_ID
, NULL
, BDR.CAPACITY_UNITS
, BDR1.CAPACITY_UNITS)
, BDR.RESOURCE_GROUP_NAME
, BDR.AVAILABLE_24_HOURS_FLAG
, BDR.ATTRIBUTE_CATEGORY
, BDR.ATTRIBUTE1
, BDR.ATTRIBUTE2
, BDR.ATTRIBUTE3
, BDR.ATTRIBUTE4
, BDR.ATTRIBUTE5
, BDR.ATTRIBUTE6
, BDR.ATTRIBUTE7
, BDR.ATTRIBUTE8
, BDR.ATTRIBUTE9
, BDR.ATTRIBUTE10
, BDR.ATTRIBUTE11
, BDR.ATTRIBUTE12
, BDR.ATTRIBUTE13
, BDR.ATTRIBUTE14
, BDR.ATTRIBUTE15
, BDR.REQUEST_ID
, BDR.PROGRAM_APPLICATION_ID
, BDR.PROGRAM_ID
, BDR.PROGRAM_UPDATE_DATE
, BD.DEPARTMENT_CODE
, BD.DISABLE_DATE
, BR.DISABLE_DATE
, BR.ORGANIZATION_ID
, BDR.EXCEPTION_SET_NAME
, DECODE(BDR.SHARE_FROM_DEPT_ID
, NULL
, BDR.CTP_FLAG
, BDR1.CTP_FLAG)
, BDR.ATP_RULE_ID
, ATP.RULE_NAME
, BDR.UTILIZATION*100
, BDR.EFFICIENCY*100
, BDR.SCHEDULE_TO_INSTANCE
, BDR.SEQUENCING_WINDOW
, BDR.IDLE_TIME_TOLERANCE
FROM MTL_ATP_RULES ATP
, BOM_DEPARTMENT_RESOURCES BDR
, BOM_DEPARTMENT_RESOURCES BDR1
, BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
WHERE BDR.RESOURCE_ID = BR.RESOURCE_ID
AND BDR.SHARE_FROM_DEPT_ID = BD.DEPARTMENT_ID(+)
AND BDR.SHARE_FROM_DEPT_ID = BDR1.DEPARTMENT_ID (+)
AND BDR.RESOURCE_ID = BDR1.RESOURCE_ID (+)
AND BDR.ATP_RULE_ID = ATP.RULE_ID (+)