DBA Data[Home] [Help]

APPS.INV_REPLENISH_DETAIL_PUB dependencies on STANDARD

Line 516: WHERE mmtt.standard_operation_id = wutta.user_task_type_id

512: FOR b in l_transaction_id.first..l_transaction_id.last
513: LOOP
514: /*SELECT wutta. honor_case_pick_flag into honor_case_pick
515: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta
516: WHERE mmtt.standard_operation_id = wutta.user_task_type_id
517: AND mmtt.organization_id = wutta.organization_id
518: AND mmtt.transaction_temp_id = l_transaction_id(b);*/
519:
520: SELECT count (*) into l_honor_case_pick_count

Line 522: WHERE mmtt.standard_operation_id = wutta.user_task_type_id

518: AND mmtt.transaction_temp_id = l_transaction_id(b);*/
519:
520: SELECT count (*) into l_honor_case_pick_count
521: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta
522: WHERE mmtt.standard_operation_id = wutta.user_task_type_id
523: AND mmtt.organization_id = wutta.organization_id
524: AND mmtt.transaction_temp_id = l_transaction_id(b)
525: AND honor_case_pick_flag = 'Y';
526: