DBA Data[Home] [Help]

APPS.WSMPLBMI dependencies on BOM_OPERATION_NETWORKS

Line 1857: --from bom_operation_networks

1853: begin
1854: --BC: CZH.I_OED-1, this sql doesn't suffice because the operation can be disabled
1855: --select 1
1856: --into l_temp
1857: --from bom_operation_networks
1858: --where from_op_seq_id = l_wo_op_seq_id
1859: --and to_op_seq_id = l_op_seq_id
1860: --and nvl(disable_date, sysdate) >= sysdate
1861: --and nvl(effectivity_date, sysdate) <= sysdate;

Line 1866: --from bom_operation_networks bon,

1862:
1863: -- BC: CZH.I_OED-2, should consider op replacement
1864: --select 1
1865: --into l_temp
1866: --from bom_operation_networks bon,
1867: -- bom_operation_sequences bos
1868: --where bon.from_op_seq_id = l_wo_op_seq_id
1869: --and bon.to_op_seq_id = l_op_seq_id
1870: --and bos.operation_sequence_id = l_op_seq_id

Line 1878: from bom_operation_networks

1874: --and nvl(bon.effectivity_date, l_rtg_revision_date) <= l_rtg_revision_date; -- not used
1875:
1876: select 1
1877: into l_temp
1878: from bom_operation_networks
1879: --where WSMPUTIL.replacement_op_seq_id (
1880: -- from_op_seq_id,
1881: -- l_rtg_revision_date) = l_wo_op_seq_id
1882: where from_op_seq_id IN (