DBA Data[Home] [Help]

APPS.WSMPVLDT dependencies on BOM_OPERATION_NETWORKS

Line 8083: from bom_operation_networks bon,

8079: AND txn.transaction_type_id = WSMPCNST.BONUS)
8080: AND nvl(wrji.starting_std_op_id, -9999) = nvl(l_bos_std_op_id, -9999)
8081: AND not exists
8082: ( select 'Is Primary Path'
8083: from bom_operation_networks bon,
8084: bom_operation_sequences bos
8085: where bon.transition_type = 1 -- Primary
8086: and nvl(bon.disable_date, sysdate+1) > sysdate
8087: --BC: CZH.I_OED-2

Line 8101: from bom_operation_networks bon,

8097:
8098: UNION
8099:
8100: select 'Is Primary Path'
8101: from bom_operation_networks bon,
8102: bom_operation_sequences bos
8103: --BC: CZH.I_OED-2
8104: --where bon.to_op_seq_id = bos.operation_sequence_id
8105: where WSMPUTIL.replacement_op_seq_id(

Line 8114: from bom_operation_networks bon1,

8110: -- BA NSO-WLT
8111: and bos.operation_seq_num = wrji.starting_operation_seq_num
8112: -- BA NSO-WLT
8113: and bon.to_op_seq_id not in ( select bon1.from_op_seq_id
8114: from bom_operation_networks bon1,
8115: bom_operation_sequences bos1
8116: --BC: CZH.I_OED-2
8117: --where bon1.from_op_seq_id = bos1.operation_sequence_id
8118: where WSMPUTIL.replacement_op_seq_id (