APPS.EAM_FORECAST_PVT dependencies on WIP_OPERATION_RESOURCES

Line 94: FROM bom_resources br, wip_operation_resources wor

90: 'Overhead', 4) mfg_cost_element,
91: decode(nvl(cdv.resource_seq_num, -1),
92: -1, 3,
93: decode((SELECT resource_type
94: FROM bom_resources br, wip_operation_resources wor
95: WHERE br.resource_id = wor.resource_id
96: AND wor.wip_ENTITY_ID = cdv.wip_entity_id
97: AND wor.operation_seq_num = cdv.operation_seq_num
98: AND wor.resource_seq_num = cdv.resource_seq_num),

Line 2169: FROM WIP_OPERATION_RESOURCES

2165: MAXIMUM_ASSIGNED_UNITS, FIRM_FLAG, GROUP_SEQUENCE_ID,
2166: GROUP_SEQUENCE_NUMBER, ACTUAL_START_DATE, ACTUAL_COMPLETION_DATE,
2167: PROJECTED_COMPLETION_DATE,p_forecast_rec.forecast_id AS FORECAST_ID
2168:
2169: FROM WIP_OPERATION_RESOURCES
2170: WHERE wip_entity_id = p_wip_id_table(j);
2171:
2172:
2173: debug('COMPLETE WOR COPY');