DBA Data[Home] [Help]

APPS.INV_REPLENISH_DETAIL_PUB dependencies on STANDARD

Line 559: WHERE mmtt.standard_operation_id = wutta.user_task_type_id

555: FOR b in l_transaction_id.first..l_transaction_id.last
556: LOOP
557: /*SELECT wutta. honor_case_pick_flag into honor_case_pick
558: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta
559: WHERE mmtt.standard_operation_id = wutta.user_task_type_id
560: AND mmtt.organization_id = wutta.organization_id
561: AND mmtt.transaction_temp_id = l_transaction_id(b);*/
562:
563: SELECT count (*) into l_honor_case_pick_count

Line 565: WHERE mmtt.standard_operation_id = wutta.user_task_type_id

561: AND mmtt.transaction_temp_id = l_transaction_id(b);*/
562:
563: SELECT count (*) into l_honor_case_pick_count
564: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta
565: WHERE mmtt.standard_operation_id = wutta.user_task_type_id
566: AND mmtt.organization_id = wutta.organization_id
567: AND mmtt.transaction_temp_id = l_transaction_id(b)
568: AND honor_case_pick_flag = 'Y';
569: