1824:
1825: --
1826: -- Update the ROUTING. Disable the operation sequences
1827: --
1828: UPDATE bom_operation_sequences bos
1829: SET disable_date = greatest(least(nvl(bos.disable_date,sysdate)),
1830: bos.effectivity_date),
1831: LAST_UPDATE_DATE = SYSDATE,
1832: LAST_UPDATED_BY = p_user_id,
1872:
1873: --
1874: -- Update the ROUTING. Disable the operation sequences
1875: --
1876: UPDATE bom_operation_sequences bos
1877: SET disable_date = greatest(least(nvl(bos.disable_date,sysdate)),
1878: bos.effectivity_date),
1879: LAST_UPDATE_DATE = SYSDATE,
1880: LAST_UPDATED_BY = p_user_id,