DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on WMS_USER_TASK_TYPE_ATTRIBUTES

Line 1003: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta , wms_page_templates_tl pgtl, WMS_PAGE_TEMPLATES_VL pgvl

999: END IF;
1000:
1001: BEGIN
1002: SELECT wutta.honor_case_pick_flag, pgvl.template_name into l_honor_case_pick_flag, l_template_name
1003: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta , wms_page_templates_tl pgtl, WMS_PAGE_TEMPLATES_VL pgvl
1004: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1005: AND mmtt.standard_operation_id = wutta.user_task_type_id
1006: AND mmtt.organization_id = wutta.organization_id
1007: AND pgtl.template_id = wutta.pick_load_page_template_id