APPS.EAM_WO_SCHEDULE_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 926: BOM_DEPARTMENT_RESOURCES DR1,

922: DECODE(WOR.SCHEDULED_FLAG, 1, DECODE(WOR.USAGE_RATE_OR_AMOUNT, 0, 2, 1),
923: WOR.SCHEDULED_FLAG) SCHEDULED_FLAG,
924: DR2.AVAILABLE_24_HOURS_FLAG AVAIL_24_HRS_FLAG
925: FROM WIP_OPERATIONS WO,
926: BOM_DEPARTMENT_RESOURCES DR1,
927: BOM_DEPARTMENT_RESOURCES DR2,
928: WIP_OPERATION_RESOURCES WOR,
929: BOM_RESOURCES RES,
930: MTL_UOM_CONVERSIONS CON

Line 927: BOM_DEPARTMENT_RESOURCES DR2,

923: WOR.SCHEDULED_FLAG) SCHEDULED_FLAG,
924: DR2.AVAILABLE_24_HOURS_FLAG AVAIL_24_HRS_FLAG
925: FROM WIP_OPERATIONS WO,
926: BOM_DEPARTMENT_RESOURCES DR1,
927: BOM_DEPARTMENT_RESOURCES DR2,
928: WIP_OPERATION_RESOURCES WOR,
929: BOM_RESOURCES RES,
930: MTL_UOM_CONVERSIONS CON
931: WHERE

Line 1033: BOM_DEPARTMENT_RESOURCES BDR,

1029: SHF.FROM_TIME FROM_TIME,
1030: SHF.TO_TIME TO_TIME
1031: FROM BOM_SHIFT_TIMES SHF,
1032: BOM_RESOURCE_SHIFTS RSH,
1033: BOM_DEPARTMENT_RESOURCES BDR,
1034: WIP_OPERATION_RESOURCES WOR,
1035: WIP_OPERATIONS WO
1036: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1037: AND WO.ORGANIZATION_ID = p_organization_id

Line 1058: BOM_DEPARTMENT_RESOURCES BDR,

1054: SHF.FROM_TIME FROM_TIME,
1055: SHF.TO_TIME TO_TIME
1056: FROM BOM_SHIFT_TIMES SHF,
1057: BOM_RESOURCE_SHIFTS RSH,
1058: BOM_DEPARTMENT_RESOURCES BDR,
1059: WIP_OPERATION_RESOURCES WOR,
1060: WIP_OPERATIONS WO
1061: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1062: AND WO.ORGANIZATION_ID = p_organization_id