APPS.M4R_7B5_OSFM_PKG dependencies on WSM_WIP_GENEALOGY_V

Line 669: g_exception_tracking_msg := 'Query WSM_WIP_GENEALOGY_V for Assembly parameters';

665: cln_debug_pub.Add('WIP Routing Seq Number : ' || l_rout_seq_num, 1);
666: cln_debug_pub.Add('OSFM Org ID : ' || l_osfm_org_id, 1);
667: END IF;
668:
669: g_exception_tracking_msg := 'Query WSM_WIP_GENEALOGY_V for Assembly parameters';
670:
671: -- gets the Job Name, Assembly Name
672: SELECT wip_entity_name,item_number
673: INTO l_job_num,l_assembly_name

Line 674: FROM WSM_WIP_GENEALOGY_V

670:
671: -- gets the Job Name, Assembly Name
672: SELECT wip_entity_name,item_number
673: INTO l_job_num,l_assembly_name
674: FROM WSM_WIP_GENEALOGY_V
675: WHERE WIP_ENTITY_ID = l_wip_entity_id
676: AND organization_id = l_osfm_org_id;
677:
678: IF (g_debug_level <= 1) THEN