eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSM_WLT_VALIDATE_PVT dependencies on BOM_OPERATION_SEQUENCES

Line 6901: bom_operation_sequences BOS,

6897: p_new_op_seq_id,
6898: p_new_std_op_id,
6899: p_new_dept_id
6900: FROM bom_standard_operations BSO,
6901: bom_operation_sequences BOS,
6902: bom_departments BD
6903: WHERE BOS.routing_sequence_id = p_new_comm_rtg_seq_id
6904: AND BSO.standard_operation_id = BOS.standard_operation_id
6905: AND BSO.standard_operation_id = p_curr_std_op_id

Line 7049: bom_operation_sequences BOS,

7045: p_new_op_seq_id,
7046: p_new_std_op_id,
7047: p_new_dept_id
7048: FROM bom_standard_operations BSO,
7049: bom_operation_sequences BOS,
7050: bom_departments BD
7051: WHERE BOS.routing_sequence_id = p_new_comm_rtg_seq_id
7052: AND BOS.operation_seq_num = nvl(p_new_op_seq_num,BOS.operation_seq_num)
7053: AND BOS.operation_sequence_id = nvl(p_new_op_seq_id,BOS.operation_sequence_id)

Line 7085: bom_operation_sequences BOS,

7081: p_new_op_seq_id,
7082: p_new_std_op_id,
7083: p_new_dept_id
7084: FROM bom_standard_operations BSO,
7085: bom_operation_sequences BOS,
7086: bom_departments BD
7087: WHERE BOS.routing_sequence_id = p_new_comm_rtg_seq_id
7088: AND BOS.operation_seq_num = nvl(p_new_op_seq_num,BOS.operation_seq_num)
7089: AND BOS.operation_sequence_id = nvl(p_new_op_seq_id,BOS.operation_sequence_id)

Line 7921: from bom_operation_sequences BOS,

7917: bso.OPERATION_CODE
7918: into p_start_op_seq_num,
7919: p_start_op_seq_id,
7920: p_start_op_seq_code
7921: from bom_operation_sequences BOS,
7922: bom_standard_operations BSO
7923: where bos.OPERATION_SEQUENCE_ID = l_start_op_seq_id
7924: and BOS.routing_sequence_id = p_rtg_seq_id
7925: and BSO.standard_operation_id (+) = BOS.standard_operation_id

Line 7948: from bom_operation_sequences BOS,

7944:
7945: BEGIN
7946: select 1
7947: into l_flag
7948: from bom_operation_sequences BOS,
7949: bom_standard_operations BSO
7950: where bos.OPERATION_SEQ_NUM = nvl(p_start_op_seq_num,bos.OPERATION_SEQ_NUM)
7951: and bos.OPERATION_SEQUENCE_ID = nvl(p_start_op_seq_id,bos.OPERATION_SEQUENCE_ID)
7952: -- ST : Fix for bug 5116062 : Added an outer NVL clause

Line 7984: bom_operation_sequences bos

7980: into l_primary
7981: from dual
7982: where 1 in ( select 1
7983: from bom_operation_networks bon,
7984: bom_operation_sequences bos
7985: where bon.transition_type = 1 -- Primary
7986: and nvl(bon.disable_date, sysdate+1) > p_revision_date -- or is it sysdate
7987: -- Start : Fix for bug 4494368/4576184 --
7988: --and WSMPUTIL.replacement_op_seq_id(bon.from_op_seq_id,

Line 8000: bom_operation_sequences bos

7996: UNION
7997:
7998: select 1
7999: from bom_operation_networks bon,
8000: bom_operation_sequences bos
8001: -- Start : Fix for bug 4494368/4576184 --
8002: --where WSMPUTIL.replacement_op_seq_id(bon.to_op_seq_id,
8003: -- p_revision_date) = bos.operation_sequence_id
8004: where bon.to_op_seq_id = bos.operation_sequence_id

Line 8011: bom_operation_sequences bos1

8007: and bos.routing_sequence_id = p_rtg_seq_id
8008: and bos.operation_seq_num = p_start_op_seq_num
8009: and bon.to_op_seq_id not in ( select bon1.from_op_seq_id
8010: from bom_operation_networks bon1,
8011: bom_operation_sequences bos1
8012: where WSMPUTIL.replacement_op_seq_id (
8013: bon1.from_op_seq_id,
8014: p_revision_date) = bos1.operation_sequence_id
8015: and bos1.routing_sequence_id = p_rtg_seq_id)