DBA Data[Home] [Help]

APPS.CTO_DEACTIVATE_CONFIG_PK dependencies on BOM_OPERATION_SEQUENCES

Line 1828: UPDATE bom_operation_sequences bos

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,

Line 1876: UPDATE bom_operation_sequences bos

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,