DBA Data[Home] [Help]

APPS.FLM_COPY_ROUTING dependencies on FLM_UTIL

Line 264: Select flm_util.get_key_flex_item(assembly_item_id,p_organization_id) Assembly_Item_Name

260: and assembly_item_id = p_item_id
261: and (nvl(alternate_bom_designator,'NONE') = nvl(p_alternate,'NONE'));
262:
263: Cursor c_routing_header(p_routing_sequence_id number) Is
264: Select flm_util.get_key_flex_item(assembly_item_id,p_organization_id) Assembly_Item_Name
265: ,l_org_code Organization_Code
266: ,p_alternate_code_to Alternate_Routing_Code
267: ,2 Eng_Routing_Flag --eng_routing_flag is oAlternate_Routing_Codepposite of routing_type
268: ,flm_util.get_key_flex_item(common_assembly_item_id,p_organization_id) Common_Assembly_Item_Name

Line 268: ,flm_util.get_key_flex_item(common_assembly_item_id,p_organization_id) Common_Assembly_Item_Name

264: Select flm_util.get_key_flex_item(assembly_item_id,p_organization_id) Assembly_Item_Name
265: ,l_org_code Organization_Code
266: ,p_alternate_code_to Alternate_Routing_Code
267: ,2 Eng_Routing_Flag --eng_routing_flag is oAlternate_Routing_Codepposite of routing_type
268: ,flm_util.get_key_flex_item(common_assembly_item_id,p_organization_id) Common_Assembly_Item_Name
269: ,routing_comment Routing_Comment
270: ,completion_subinventory Completion_Subinventory
271: ,flm_util.get_key_flex_location(completion_locator_id,p_organization_id) Completion_Location_Name
272: ,l_line_code Line_Code

Line 271: ,flm_util.get_key_flex_location(completion_locator_id,p_organization_id) Completion_Location_Name

267: ,2 Eng_Routing_Flag --eng_routing_flag is oAlternate_Routing_Codepposite of routing_type
268: ,flm_util.get_key_flex_item(common_assembly_item_id,p_organization_id) Common_Assembly_Item_Name
269: ,routing_comment Routing_Comment
270: ,completion_subinventory Completion_Subinventory
271: ,flm_util.get_key_flex_location(completion_locator_id,p_organization_id) Completion_Location_Name
272: ,l_line_code Line_Code
273: ,cfm_routing_flag CFM_Routing_Flag
274: ,2 Mixed_Model_Map_Flag -- mixed_model_map_flag has only one 'Y'=1 for an item
275: ,priority Priority