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.WSMPUTIL dependencies on BOM_OPERATION_NETWORKS

Line 167: FROM bom_operation_networks bon

163:
164: -- BC: CZH I_OED-1
165: CURSOR get_start IS
166: SELECT UNIQUE bon.from_op_seq_id
167: FROM bom_operation_networks bon
168: WHERE bon.from_op_seq_id IN (
169: SELECT operation_sequence_id
170: FROM bom_operation_sequences
171: WHERE routing_sequence_id = p_routing_sequence_id

Line 175: FROM bom_operation_networks bon1

171: WHERE routing_sequence_id = p_routing_sequence_id
172: )
173: AND NOT EXISTS ( --bon.from_op_seq_id NOT IN
174: SELECT 'X' --unique bon1.to_op_seq_id
175: FROM bom_operation_networks bon1
176: WHERE bon1.to_op_seq_id = bon.from_op_seq_id
177: AND EXISTS ( --bon1.to_op_seq_id IN
178: SELECT 'X' --operation_sequence_id
179: FROM bom_operation_sequences

Line 197: FROM bom_operation_networks bon

193: -- BA: CZH.I_OED-1.BUG2558058, no network defined
194: -- error_code -1 is reserved for WSM_NO_NETWORK_EXISTS
195: SELECT count(*)
196: INTO l_count
197: FROM bom_operation_networks bon
198: WHERE bon.from_op_seq_id IN (
199: SELECT operation_sequence_id
200: FROM bom_operation_sequences
201: WHERE routing_sequence_id = p_routing_sequence_id

Line 334: FROM bom_operation_networks bon

330:
331: -- BC: CZH I_OED-1
332: CURSOR get_end IS
333: SELECT UNIQUE bon.to_op_seq_id
334: FROM bom_operation_networks bon
335: WHERE bon.to_op_seq_id IN (
336: SELECT operation_sequence_id
337: FROM bom_operation_sequences
338: WHERE routing_sequence_id = p_routing_sequence_id

Line 342: FROM bom_operation_networks bon1

338: WHERE routing_sequence_id = p_routing_sequence_id
339: )
340: AND NOT EXISTS ( --bon.from_op_seq_id NOT IN
341: SELECT 'X' --unique bon1.to_op_seq_id
342: FROM bom_operation_networks bon1
343: WHERE bon1.from_op_seq_id = bon.to_op_seq_id
344: AND EXISTS ( --bon1.to_op_seq_id IN
345: SELECT 'X' --operation_sequence_id
346: FROM bom_operation_sequences

Line 365: FROM bom_operation_networks bon

361: -- BA: CZH.I_OED-1.BUG2558058, no network defined
362: -- error_code -1 is reserved for WSM_NO_NETWORK_EXISTS
363: SELECT count(*)
364: INTO l_count
365: FROM bom_operation_networks bon
366: WHERE bon.from_op_seq_id IN (
367: SELECT operation_sequence_id
368: FROM bom_operation_sequences
369: WHERE routing_sequence_id = p_routing_sequence_id

Line 883: from bom_operation_networks bon,

879: declare
880: cursor get_ops is
881: select bos.operation_seq_num op_seq_num,
882: bos.operation_sequence_id op_seq_id
883: from bom_operation_networks bon,
884: bom_operation_sequences bos
885: where bos.routing_sequence_id = p_routing_sequence_id
886: and bon.from_op_seq_id = bos.operation_sequence_id
887: union

Line 890: from bom_operation_networks bon,

886: and bon.from_op_seq_id = bos.operation_sequence_id
887: union
888: select bos.operation_seq_num op_seq_num,
889: bos.operation_sequence_id op_seq_id
890: from bom_operation_networks bon,
891: bom_operation_sequences bos
892: where bos.routing_sequence_id = p_routing_sequence_id
893: and bon.to_op_seq_id = bos.operation_sequence_id;
894:

Line 918: FROM bom_operation_networks

914: BEGIN
915:
916: SELECT 1
917: INTO dumnum
918: FROM bom_operation_networks
919: WHERE from_op_seq_id = start_id
920: AND transition_type = 1;
921:
922: EXCEPTION

Line 944: FROM bom_operation_networks

940: BEGIN
941:
942: SELECT 1
943: INTO dumnum
944: FROM bom_operation_networks
945: WHERE to_op_seq_id = end_id
946: AND transition_type =1 ;
947:
948: EXCEPTION

Line 978: from bom_operation_networks bon

974:
975: select bos1.operation_seq_num
976: , bos2.operation_seq_num
977: into l_from_opseq_num, l_to_opseq_num
978: from bom_operation_networks bon
979: , bom_operation_sequences bos1
980: , bom_operation_sequences bos2
981: where bos1.routing_sequence_id = p_routing_sequence_id
982: and bos2.routing_sequence_id = bos1.routing_sequence_id

Line 1020: FROM BOM_OPERATION_NETWORKS_V

1016: BEGIN
1017:
1018: SELECT count(*)
1019: INTO p_count
1020: FROM BOM_OPERATION_NETWORKS_V
1021: WHERE routing_sequence_id = p_routing_sequence_id
1022: AND transition_type = 1
1023: AND from_op_seq_id NOT IN
1024: (SELECT to_op_seq_id

Line 1025: FROM BOM_OPERATION_NETWORKS_V

1021: WHERE routing_sequence_id = p_routing_sequence_id
1022: AND transition_type = 1
1023: AND from_op_seq_id NOT IN
1024: (SELECT to_op_seq_id
1025: FROM BOM_OPERATION_NETWORKS_V
1026: WHERE routing_sequence_id = p_routing_sequence_id
1027: AND transition_type = 1 );
1028:
1029: IF p_count > 1 THEN

Line 1045: FROM bom_operation_networks_v

1041:
1042: BEGIN
1043: SELECT to_op_seq_id, to_seq_num
1044: INTO x_temp,x_meet_num
1045: FROM bom_operation_networks_v
1046: WHERE from_op_seq_id = x_from_id
1047: AND transition_type = 1;
1048:
1049: EXCEPTION

Line 1070: FROM BOM_OPERATION_NETWORKS

1066:
1067: BEGIN
1068: SELECT count(*)
1069: INTO p_count
1070: FROM BOM_OPERATION_NETWORKS
1071: WHERE to_op_seq_id = x_from_id
1072: AND transition_type = 1;
1073:
1074: IF p_count > 1 THEN

Line 1077: FROM BOM_OPERATION_NETWORKS_V

1073:
1074: IF p_count > 1 THEN
1075: SELECT from_seq_num
1076: INTO x_meet_num
1077: FROM BOM_OPERATION_NETWORKS_V
1078: WHERE from_op_seq_id = x_from_id;
1079:
1080: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_PATHS_MEET');
1081: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);

Line 1802: FROM bom_operation_networks_v

1798: p_from_seq_num NUMBER;
1799:
1800: CURSOR check_percentage_sum IS
1801: SELECT distinct (from_seq_num)
1802: FROM bom_operation_networks_v
1803: WHERE routing_sequence_id = p_routing_sequence_id
1804: ORDER BY from_seq_num ;
1805:
1806: BEGIN

Line 1816: FROM bom_operation_networks_v

1812: EXIT WHEN check_percentage_sum%NOTFOUND;
1813:
1814: SELECT SUM(planning_pct)
1815: INTO var_total_planning_pct
1816: FROM bom_operation_networks_v
1817: WHERE from_seq_num = p_from_seq_num
1818: AND transition_type IN (1, 2)
1819: AND routing_sequence_id = p_routing_sequence_id ;
1820:

Line 2075: from bom_operation_networks bon,

2071: cursor c is
2072: -- BC: CZH.I_OED-2, consider replacement
2073: select distinct bon.from_op_seq_id,
2074: bos.standard_operation_id
2075: from bom_operation_networks bon,
2076: bom_operation_sequences bos
2077: Where bos.routing_sequence_id = p_routing_sequence_id
2078: and bos.operation_sequence_id = bon.from_op_seq_id
2079: and bos.standard_operation_id = l_std_op_id --p_standard_operation_id --Fix for 2265237

Line 2085: from bom_operation_networks bon,

2081: and bos.effectivity_date <= l_rtg_rev_date -- CZH.I_OED-1
2082: UNION
2083: select distinct bon.to_op_seq_id,
2084: bos.standard_operation_id
2085: from bom_operation_networks bon,
2086: bom_operation_sequences bos
2087: Where bos.routing_sequence_id = p_routing_sequence_id
2088: and bos.operation_sequence_id = bon.to_op_seq_id
2089: and bos.standard_operation_id = l_std_op_id --p_standard_operation_id --Fix for 2265237

Line 2095: from bom_operation_networks bon,

2091: and bos.effectivity_date <= l_rtg_rev_date; --CZH.I_OED-1
2092: select distinct
2093: bos.operation_sequence_id,
2094: bos.standard_operation_id
2095: from bom_operation_networks bon,
2096: bom_operation_sequences bos
2097: Where bos.routing_sequence_id = p_routing_sequence_id
2098: and bos.standard_operation_id = l_std_op_id
2099: and (bos.operation_sequence_id = WSMPUTIL.replacement_op_seq_id(

Line 2134: from bom_operation_networks bon_A,

2130: bom_operation_sequences bos2
2131: Where bos.routing_sequence_id = p_routing_sequence_id
2132: and bos.operation_sequence_id IN
2133: (select from_op_seq_id opseqid
2134: from bom_operation_networks bon_A,
2135: bom_operation_sequences bos_A
2136: where bos_A.routing_sequence_id = p_routing_sequence_id
2137: and bon_A.from_op_seq_id = bos_A.operation_sequence_id
2138: UNION ALL

Line 2140: from bom_operation_networks bon_B,

2136: where bos_A.routing_sequence_id = p_routing_sequence_id
2137: and bon_A.from_op_seq_id = bos_A.operation_sequence_id
2138: UNION ALL
2139: select to_op_seq_id opseqid
2140: from bom_operation_networks bon_B,
2141: bom_operation_sequences bos_B
2142: where bos_B.routing_sequence_id = p_routing_sequence_id
2143: and bon_B.from_op_seq_id = bos_B.operation_sequence_id)
2144: and bos2.routing_sequence_id = p_routing_sequence_id

Line 2870: from bom_operation_networks bon

2866:
2867: begin
2868: select 1
2869: into x_return
2870: from bom_operation_networks bon
2871: where bon.from_op_seq_id in (select bos.operation_sequence_id
2872: from bom_operation_sequences bos
2873: where bos.routing_sequence_id = p_routing_sequence_id
2874: --BC: CZH.I_OED-2, should consider replacement op

Line 2887: from bom_operation_networks bon

2883: when NO_DATA_FOUND then
2884:
2885: select 1
2886: into x_return
2887: from bom_operation_networks bon
2888: where bon.to_op_seq_id in ( select bos.operation_sequence_id
2889: from bom_operation_sequences bos
2890: where bos.routing_sequence_id = p_routing_sequence_id
2891: --BC: CZH.I_OED-2, should consider replacement op

Line 2940: FROM bom_operation_networks

2936: l_rtg_rev_date DATE;
2937:
2938: CURSOR primary_cur IS (
2939: SELECT to_op_seq_id
2940: FROM bom_operation_networks
2941: WHERE transition_type = 1
2942: START WITH from_op_seq_id = l_op_seq_id
2943: AND transition_type = 1
2944: CONNECT BY from_op_seq_id = PRIOR to_op_seq_id

Line 3122: from bom_operation_networks bon

3118: INTO l_count
3119: FROM sys.dual
3120: WHERE exists(
3121: select 1
3122: from bom_operation_networks bon
3123: --where NVL(WSMPUTIL.replacement_op_seq_id(
3124: -- bon.from_op_seq_id,
3125: -- l_rtg_rev_date), -1) = l_wo_op_seq_id
3126: where bon.from_op_seq_id IN (

Line 3210: from bom_operation_networks bon

3206: where wip_entity_id = p_wip_entity_id;
3207:
3208: select count(*)
3209: into l_count
3210: from bom_operation_networks bon
3211: where bon.from_op_seq_id = l_op_seq_id
3212: and exists (select bos.operation_sequence_id
3213: from bom_operation_sequences bos
3214: where bos.operation_sequence_id = bon.to_op_seq_id

Line 4293: BOM_OPERATION_NETWORKS_V to fetch standard operation id of

4289:
4290: /* bug fix:7387499
4291: ***************************************************************************
4292: created this function for bug fix 5529692 to call this in
4293: BOM_OPERATION_NETWORKS_V to fetch standard operation id of
4294: operation that is relatively effective at a particular operation
4295: sequence number and inturn fetch its op code
4296: **************************************************************************/
4297:

Line 4330: BOM_OPERATION_NETWORKS_V to fetch standard department id of

4326: end get_eff_stdop_id;
4327:
4328: /****************************************************************************************************
4329: Created this function for bug fix 5529692 to call this in
4330: BOM_OPERATION_NETWORKS_V to fetch standard department id of
4331: operation that is relatively effective at a particular operation
4332: sequence number and inturn fetch its department code
4333: ****************************************************************************************************/
4334: