DBA Data[Home] [Help]

APPS.WIP_WPS_COMMON dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 1683: delete wip_operation_resource_usage woru

1679: where wor.wip_entity_id = p_wip_entity_id
1680: and wor.operation_seq_num = p_operation_seq_num
1681: and wor.resource_seq_num = p_resource_seq_num;
1682: -- delete usage
1683: delete wip_operation_resource_usage woru
1684: where woru.wip_entity_id = p_wip_entity_id
1685: and woru.operation_seq_num = p_operation_seq_num
1686: and woru.resource_seq_num = p_resource_seq_num;
1687: -- update instances if any

Line 1707: delete wip_operation_resource_usage woru

1703: where wor.wip_entity_id = p_wip_entity_id
1704: and wor.operation_seq_num = p_operation_seq_num
1705: and wor.schedule_seq_num = l_sched_seq_num;
1706: -- delete usages
1707: delete wip_operation_resource_usage woru
1708: where woru.wip_entity_id = p_wip_entity_id
1709: and woru.operation_seq_num = p_operation_seq_num
1710: and woru.resource_seq_num in
1711: ( select wor.resource_seq_num from wip_operation_resources wor