APPS.EAM_WO_SCHEDULE_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 945: BOM_DEPARTMENT_RESOURCES DR1,

941: DECODE(WOR.SCHEDULED_FLAG, 1, DECODE(WOR.USAGE_RATE_OR_AMOUNT, 0, 2, 1),
942: WOR.SCHEDULED_FLAG) SCHEDULED_FLAG,
943: DR2.AVAILABLE_24_HOURS_FLAG AVAIL_24_HRS_FLAG
944: FROM WIP_OPERATIONS WO,
945: BOM_DEPARTMENT_RESOURCES DR1,
946: BOM_DEPARTMENT_RESOURCES DR2,
947: WIP_OPERATION_RESOURCES WOR,
948: BOM_RESOURCES RES,
949: MTL_UOM_CONVERSIONS CON

Line 946: BOM_DEPARTMENT_RESOURCES DR2,

942: WOR.SCHEDULED_FLAG) SCHEDULED_FLAG,
943: DR2.AVAILABLE_24_HOURS_FLAG AVAIL_24_HRS_FLAG
944: FROM WIP_OPERATIONS WO,
945: BOM_DEPARTMENT_RESOURCES DR1,
946: BOM_DEPARTMENT_RESOURCES DR2,
947: WIP_OPERATION_RESOURCES WOR,
948: BOM_RESOURCES RES,
949: MTL_UOM_CONVERSIONS CON
950: WHERE

Line 1052: BOM_DEPARTMENT_RESOURCES BDR,

1048: SHF.FROM_TIME FROM_TIME,
1049: SHF.TO_TIME TO_TIME
1050: FROM BOM_SHIFT_TIMES SHF,
1051: BOM_RESOURCE_SHIFTS RSH,
1052: BOM_DEPARTMENT_RESOURCES BDR,
1053: WIP_OPERATION_RESOURCES WOR,
1054: WIP_OPERATIONS WO
1055: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1056: AND WO.ORGANIZATION_ID = p_organization_id

Line 1077: BOM_DEPARTMENT_RESOURCES BDR,

1073: SHF.FROM_TIME FROM_TIME,
1074: SHF.TO_TIME TO_TIME
1075: FROM BOM_SHIFT_TIMES SHF,
1076: BOM_RESOURCE_SHIFTS RSH,
1077: BOM_DEPARTMENT_RESOURCES BDR,
1078: WIP_OPERATION_RESOURCES WOR,
1079: WIP_OPERATIONS WO
1080: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1081: AND WO.ORGANIZATION_ID = p_organization_id