DBA Data[Home] [Help]

APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on WIP_OPERATION_RESOURCES

Line 1163: FROM wip_operation_resources wor

1159:
1160: begin
1161: SELECT wor.usage_rate_or_amount
1162: INTO l_usage_rate_or_amount
1163: FROM wip_operation_resources wor
1164: WHERE wor.wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1165: and NVL(wor.repetitive_schedule_id, -1) = NVL(g_ShopFloorMove_rec.repetitive_schedule_id, -1)
1166: and wor.operation_seq_num = g_ShopFloorMove_rec.fm_operation_seq_num
1167: and wor.organization_id = g_ShopFloorMove_rec.organization_id