1845: ORDER BY assembly_item_id;
1846:
1847: CURSOR CheckForProcessSavedMap IS
1848: SELECT mixed_model_map_id
1849: FROM bom_mixed_model_map_header
1850: WHERE line_id = p_line_id
1851: AND ((p_family_item_id is NULL AND family_item_id is NULL)
1852: OR (family_item_id = p_family_item_id))
1853: AND organization_id = p_org_id
1854: AND process_or_lineop = G_PROCESS;
1855:
1856: CURSOR CheckForLineopSavedMap IS
1857: SELECT mixed_model_map_id
1858: FROM bom_mixed_model_map_header
1859: WHERE line_id = p_line_id
1860: AND ((p_family_item_id is NULL AND family_item_id is NULL)
1861: OR (family_item_id = p_family_item_id))
1862: AND organization_id = p_org_id