DBA Data[Home] [Help]

APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on WIP_OPERATION_RESOURCES

Line 1119: FROM wip_operation_resources wor

1115:
1116: begin
1117: SELECT wor.usage_rate_or_amount
1118: INTO l_usage_rate_or_amount
1119: FROM wip_operation_resources wor
1120: WHERE wor.wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1121: and NVL(wor.repetitive_schedule_id, -1) = NVL(g_ShopFloorMove_rec.repetitive_schedule_id, -1)
1122: and wor.operation_seq_num = g_ShopFloorMove_rec.fm_operation_seq_num
1123: and wor.organization_id = g_ShopFloorMove_rec.organization_id