Product: | BOM - Bills of Material |
---|---|
Description: | Resources associated with departments |
Implementation/DBA Data: | APPS.BOM_DEPARTMENT_RESOURCES_V |
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 (+)