APPS.WSM_JOBCOPIES_PVT dependencies on WSM_COPY_OP_RESOURCE_USAGE

Line 1083: DELETE WSM_COPY_OP_RESOURCE_USAGE

1079:
1080: DELETE WSM_COPY_OP_RESOURCE_INSTANCES
1081: WHERE wip_entity_id = p_wip_entity_id;
1082:
1083: DELETE WSM_COPY_OP_RESOURCE_USAGE
1084: WHERE wip_entity_id = p_wip_entity_id;
1085:
1086: DELETE WSM_COPY_REQUIREMENT_OPS
1087: WHERE wip_entity_id = p_wip_entity_id;

Line 4171: DELETE WSM_COPY_OP_RESOURCE_USAGE

4167:
4168: DELETE WSM_COPY_OP_RESOURCE_INSTANCES
4169: WHERE wip_entity_id = p_new_wip_entity_id;
4170:
4171: DELETE WSM_COPY_OP_RESOURCE_USAGE
4172: WHERE wip_entity_id = p_new_wip_entity_id;
4173:
4174: DELETE WSM_COPY_REQUIREMENT_OPS
4175: WHERE wip_entity_id = p_new_wip_entity_id;

Line 5312: DELETE WSM_COPY_OP_RESOURCE_USAGE

5308:
5309: DELETE WSM_COPY_OP_RESOURCE_INSTANCES
5310: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5311:
5312: DELETE WSM_COPY_OP_RESOURCE_USAGE
5313: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5314:
5315: DELETE WSM_COPY_REQUIREMENT_OPS
5316: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);

Line 6006: WSM_COPY_OP_RESOURCE_USAGE WCORU

6002: WCORU.INSTANCE_ID,
6003: WCORU.SERIAL_NUMBER,
6004: WCORU.CUMULATIVE_PROCESSING_TIME
6005: FROM WIP_OPERATION_RESOURCES WOR,
6006: WSM_COPY_OP_RESOURCE_USAGE WCORU
6007: WHERE WCORU.WIP_ENTITY_ID= p_wip_entity_id
6008: AND WCORU.Operation_seq_num = l_curr_op_seq_num
6009: AND WOR.WIP_ENTITY_ID= WCORU.WIP_ENTITY_ID
6010: AND WOR.Operation_seq_num= WCORU.Operation_seq_num