DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on WMS_PAGE_TEMPLATES_VL

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

1216: END IF;
1217:
1218: BEGIN
1219: SELECT wutta.honor_case_pick_flag, pgvl.template_name into l_honor_case_pick_flag, l_template_name
1220: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta , wms_page_templates_tl pgtl, WMS_PAGE_TEMPLATES_VL pgvl
1221: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1222: AND mmtt.standard_operation_id = wutta.user_task_type_id
1223: AND mmtt.organization_id = wutta.organization_id
1224: AND pgtl.template_id = wutta.pick_load_page_template_id