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

Line 265: FROM bom_operation_networks_v bonv,

261: /* CURSOR start_ops_cur IS
262: SELECT DISTINCT from_op_seq_id start_op_seq_id,
263: from_seq_num start_op_seq_num,
264: nvl(yield, 1) start_op_yield
265: FROM bom_operation_networks_v bonv,
266: bom_operation_sequences bos
267: WHERE bonv.routing_sequence_id = p_routing_sequence_id
268: AND bonv.operation_type = p_operation_type
269: AND bonv.transition_type <> 3

Line 272: FROM bom_operation_networks net

268: AND bonv.operation_type = p_operation_type
269: AND bonv.transition_type <> 3
270: AND bonv.from_op_seq_id = bos.operation_sequence_id
271: AND NOT EXISTS (SELECT NULL
272: FROM bom_operation_networks net
273: WHERE net.to_op_seq_id = bonv.from_op_seq_id
274: AND net.transition_type <> 3)
275: ORDER BY from_seq_num;*/
276: -- BUG 4506235

Line 281: FROM bom_operation_networks_v bonv,

277: CURSOR start_ops_cur IS
278: SELECT DISTINCT from_op_seq_id start_op_seq_id,
279: from_seq_num start_op_seq_num,
280: DECODE(borv.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1)) start_op_yield
281: FROM bom_operation_networks_v bonv,
282: bom_operation_sequences bos,
283: bom_operational_routings_v borv
284: WHERE bonv.routing_sequence_id = borv.routing_Sequence_id
285: AND bonv.routing_sequence_id = p_routing_sequence_id

Line 290: FROM bom_operation_networks net

286: AND bonv.operation_type = p_operation_type
287: AND bonv.transition_type <> 3
288: AND bonv.from_op_seq_id = bos.operation_sequence_id
289: AND NOT EXISTS (SELECT NULL
290: FROM bom_operation_networks net
291: WHERE net.to_op_seq_id = bonv.from_op_seq_id
292: AND net.transition_type <> 3)
293: ORDER BY from_seq_num;
294:

Line 298: ( SELECT null FROM bom_operation_networks_v bonv

294:
295: CURSOR check_nwk_links_cur IS
296: SELECT null FROM DUAL
297: WHERE exists
298: ( SELECT null FROM bom_operation_networks_v bonv
299: WHERE bonv.routing_sequence_id = p_routing_sequence_id
300: AND bonv.operation_type = p_operation_type
301: AND bonv.transition_type <> 3 );
302: /****

Line 310: SELECT COUNT(*) FROM bom_operation_networks

306: WHERE bor.routing_sequence_id = p_routing_sequence_id;
307: ****/
308:
309: CURSOR check_nwk_exists_cur( p_rtg_seq_id NUMBER ) IS -- BUG 4348554
310: SELECT COUNT(*) FROM bom_operation_networks
311: WHERE from_op_seq_id IN
312: ( SELECT operation_sequence_id FROM bom_operation_sequences
313: WHERE routing_sequence_id = p_rtg_seq_id )
314: OR to_op_SEQ_ID IN

Line 468: FROM bom_operation_networks_v bonv,

464: /* CURSOR start_ops_cur IS
465: SELECT DISTINCT from_op_seq_id start_op_seq_id,
466: from_seq_num start_op_seq_num,
467: nvl(yield, 1) start_op_yield
468: FROM bom_operation_networks_v bonv,
469: bom_operation_sequences bos
470: WHERE bonv.routing_sequence_id = p_routing_sequence_id
471: AND bonv.operation_type = p_operation_type
472: AND bonv.transition_type <> 3

Line 475: FROM bom_operation_networks net

471: AND bonv.operation_type = p_operation_type
472: AND bonv.transition_type <> 3
473: AND bonv.from_op_seq_id = bos.operation_sequence_id
474: AND NOT EXISTS (SELECT NULL
475: FROM bom_operation_networks net
476: WHERE net.to_op_seq_id = bonv.from_op_seq_id
477: AND net.transition_type <> 3)
478: ORDER BY from_seq_num;*/
479: -- BUG 4506235

Line 484: FROM bom_operation_networks_v bonv,

480: CURSOR start_ops_cur IS
481: SELECT DISTINCT from_op_seq_id start_op_seq_id,
482: from_seq_num start_op_seq_num,
483: DECODE(borv.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1)) start_op_yield
484: FROM bom_operation_networks_v bonv,
485: bom_operation_sequences bos,
486: bom_operational_routings_v borv
487: WHERE bonv.routing_sequence_id = borv.routing_Sequence_id
488: AND bonv.routing_sequence_id = p_routing_sequence_id

Line 493: FROM bom_operation_networks net

489: AND bonv.operation_type = p_operation_type
490: AND bonv.transition_type <> 3
491: AND bonv.from_op_seq_id = bos.operation_sequence_id
492: AND NOT EXISTS (SELECT NULL
493: FROM bom_operation_networks net
494: WHERE net.to_op_seq_id = bonv.from_op_seq_id
495: AND net.transition_type <> 3)
496: ORDER BY from_seq_num;
497:

Line 501: ( SELECT null FROM bom_operation_networks_v bonv

497:
498: CURSOR check_nwk_links_cur IS
499: SELECT null FROM DUAL
500: WHERE exists
501: ( SELECT null FROM bom_operation_networks_v bonv
502: WHERE bonv.routing_sequence_id = p_routing_sequence_id
503: AND bonv.operation_type = p_operation_type
504: AND bonv.transition_type <> 3 );
505:

Line 507: SELECT COUNT(*) FROM bom_operation_networks

503: AND bonv.operation_type = p_operation_type
504: AND bonv.transition_type <> 3 );
505:
506: CURSOR check_nwk_exists_cur( p_rtg_seq_id NUMBER ) IS -- BUG 4348554
507: SELECT COUNT(*) FROM bom_operation_networks
508: WHERE from_op_seq_id IN
509: ( SELECT operation_sequence_id FROM bom_operation_sequences
510: WHERE routing_sequence_id = p_rtg_seq_id )
511: OR to_op_SEQ_ID IN

Line 798: FROM bom_operation_networks_v bonv

794: CURSOR next_ops_cur (cv_start_op_seq_id number) IS
795: SELECT to_op_seq_id next_op_seq_id,
796: to_seq_num next_op_seq_num,
797: transition_type
798: FROM bom_operation_networks_v bonv
799: WHERE routing_sequence_id = g_rtg_seq_id
800: AND from_op_seq_id = cv_start_op_seq_id
801: AND operation_type = g_op_type
802: -- AND transition_type <> 3

Line 843: FROM bom_operation_networks

839: ) IS
840:
841: CURSOR prev_opns_cur (cv_to_seq_id number) IS
842: SELECT from_op_seq_id prev_op, planning_pct
843: FROM bom_operation_networks
844: WHERE to_op_seq_id = cv_to_seq_id
845: AND transition_type = 3;
846: j NUMBER := 0;
847: BEGIN

Line 868: FROM bom_operation_networks_v bonv

864:
865: PROCEDURE validate_operation(i NUMBER) is
866: CURSOR next_op_cur(cv_start_op_seq_id NUMBER) is
867: SELECT bonv.transition_type, bonv.planning_pct
868: FROM bom_operation_networks_v bonv
869: WHERE routing_sequence_id = g_rtg_seq_id
870: AND bonv.from_op_seq_id = cv_start_op_seq_id
871: AND bonv.operation_type = g_op_type
872: AND bonv.transition_type <> 3;

Line 906: FROM bom_operation_networks_v bonv

902: ) IS
903:
904: CURSOR end_op_cur IS
905: SELECT max(to_op_seq_id) end_op_seq_id
906: FROM bom_operation_networks_v bonv
907: WHERE bonv.routing_sequence_id = p_routing_sequence_id
908: AND bonv.operation_type = p_operation_type
909: AND bonv.transition_type <> 3
910: AND NOT EXISTS (SELECT NULL

Line 911: FROM bom_operation_networks net

907: WHERE bonv.routing_sequence_id = p_routing_sequence_id
908: AND bonv.operation_type = p_operation_type
909: AND bonv.transition_type <> 3
910: AND NOT EXISTS (SELECT NULL
911: FROM bom_operation_networks net
912: WHERE net.from_op_seq_id = bonv.to_op_seq_id
913: AND net.transition_type <> 3);
914:
915: -- For cv_start_op_seq_id, traverse the network to select all the

Line 922: FROM bom_operation_networks_v bonv

918: CURSOR next_ops_cur (cv_start_op_seq_id number) IS
919: SELECT to_op_seq_id next_op_seq_id,
920: to_seq_num next_op_seq_num,
921: transition_type
922: FROM bom_operation_networks_v bonv
923: WHERE routing_sequence_id = p_routing_sequence_id
924: AND from_op_seq_id = cv_start_op_seq_id
925: AND operation_type = p_operation_type
926: AND transition_type <> 3

Line 933: FROM bom_operation_networks_v bonv

929: CURSOR next_alt_ops_cur (cv_op_seq_id number) IS
930: SELECT to_op_seq_id next_op_seq_id,
931: to_seq_num next_op_seq_num,
932: transition_type
933: FROM bom_operation_networks_v bonv
934: WHERE routing_sequence_id = p_routing_sequence_id
935: AND from_op_seq_id = cv_op_seq_id
936: AND operation_type = p_operation_type
937: AND transition_type = 2

Line 946: FROM bom_operation_networks_v bonv

942: CURSOR rework_ops_cur (cv_start_op_seq_id number) IS
943: SELECT to_op_seq_id, to_seq_num,
944: transition_type, nvl(planning_pct, 0) planning_pct,
945: from_op_seq_id, from_seq_num
946: FROM bom_operation_networks_v bonv
947: WHERE routing_sequence_id = p_routing_sequence_id
948: AND from_op_seq_id = cv_start_op_seq_id
949: AND operation_type = p_operation_type
950: AND transition_type = 3

Line 957: FROM bom_operation_networks_v bonv

953: CURSOR rework_ops_cur1 (cv_start_op_seq_id number) IS
954: SELECT to_op_seq_id, to_seq_num,
955: transition_type, nvl(planning_pct, 0) planning_pct,
956: from_op_seq_id, from_seq_num
957: FROM bom_operation_networks_v bonv
958: WHERE routing_sequence_id = p_routing_sequence_id
959: AND from_op_seq_id = cv_start_op_seq_id
960: AND operation_type = p_operation_type
961: AND transition_type = 3

Line 966: from bom_operation_networks bon

962: ORDER BY to_seq_num;
963:
964: cursor prim_path_cur (cv_start_op_seq_id number) is
965: select bon.to_op_seq_id prim_op_seq_id
966: from bom_operation_networks bon
967: connect by prior to_op_seq_id = from_op_seq_id
968: and
969: nvl(bon.transition_type, 0) not in (2, 3)
970: start with from_op_seq_id = cv_start_op_seq_id

Line 1185: FROM bom_operation_networks_v bonv

1181: ) RETURN NUMBER IS
1182:
1183: CURSOR end_op_cur IS
1184: SELECT max(to_op_seq_id) end_op_seq_id
1185: FROM bom_operation_networks_v bonv
1186: WHERE bonv.routing_sequence_id = p_routing_sequence_id
1187: AND bonv.operation_type = p_operation_type
1188: AND bonv.transition_type <> 3
1189: AND NOT EXISTS (SELECT NULL

Line 1190: FROM bom_operation_networks net

1186: WHERE bonv.routing_sequence_id = p_routing_sequence_id
1187: AND bonv.operation_type = p_operation_type
1188: AND bonv.transition_type <> 3
1189: AND NOT EXISTS (SELECT NULL
1190: FROM bom_operation_networks net
1191: WHERE net.from_op_seq_id = bonv.to_op_seq_id
1192: AND net.transition_type <> 3);
1193:
1194: -- For cv_start_op_seq_id, traverse the network to select all the

Line 1201: FROM bom_operation_networks_v bonv

1197: CURSOR next_ops_cur (cv_start_op_seq_id number) IS
1198: SELECT to_op_seq_id next_op_seq_id,
1199: to_seq_num next_op_seq_num,
1200: transition_type
1201: FROM bom_operation_networks_v bonv
1202: WHERE routing_sequence_id = p_routing_sequence_id
1203: AND from_op_seq_id = cv_start_op_seq_id
1204: AND operation_type = p_operation_type
1205: AND transition_type <> 3

Line 1212: FROM bom_operation_networks_v bonv

1208: CURSOR next_alt_ops_cur (cv_op_seq_id number) IS
1209: SELECT to_op_seq_id next_op_seq_id,
1210: to_seq_num next_op_seq_num,
1211: transition_type
1212: FROM bom_operation_networks_v bonv
1213: WHERE routing_sequence_id = p_routing_sequence_id
1214: AND from_op_seq_id = cv_op_seq_id
1215: AND operation_type = p_operation_type
1216: AND transition_type = 2

Line 1225: FROM bom_operation_networks_v bonv

1221: CURSOR rework_ops_cur (cv_start_op_seq_id number) IS
1222: SELECT to_op_seq_id, to_seq_num,
1223: transition_type, nvl(planning_pct, 0) planning_pct,
1224: from_op_seq_id, from_seq_num
1225: FROM bom_operation_networks_v bonv
1226: WHERE routing_sequence_id = p_routing_sequence_id
1227: AND from_op_seq_id = cv_start_op_seq_id
1228: AND operation_type = p_operation_type
1229: AND transition_type = 3

Line 1235: FROM bom_operation_networks_v bonv

1231: CURSOR rework_ops_cur1 (cv_start_op_seq_id number) IS
1232: SELECT to_op_seq_id, to_seq_num,
1233: transition_type, nvl(planning_pct, 0) planning_pct,
1234: from_op_seq_id, from_seq_num
1235: FROM bom_operation_networks_v bonv
1236: WHERE routing_sequence_id = p_routing_sequence_id
1237: AND from_op_seq_id = cv_start_op_seq_id
1238: AND operation_type = p_operation_type
1239: AND transition_type = 3

Line 1378: from bom_operation_networks bon

1374: )
1375: IS
1376: cursor prim_path_fdr_cur (cv_start_op_seq_id number) is
1377: select bon.to_op_seq_id prim_op_seq_id
1378: from bom_operation_networks bon
1379: connect by prior to_op_seq_id = from_op_seq_id
1380: and
1381: nvl(bon.transition_type, 0) not in (2, 3)
1382: start with from_op_seq_id = cv_start_op_seq_id

Line 1547: --FROM bom_operation_networks_v

1543: ) IS
1544:
1545: CURSOR prev_links_cur (cv_to_seq_id number) IS
1546: SELECT from_op_seq_id prev_op, planning_pct
1547: --FROM bom_operation_networks_v
1548: FROM bom_operation_networks
1549: WHERE to_op_seq_id = cv_to_seq_id
1550: AND transition_type <> 3;
1551:

Line 1548: FROM bom_operation_networks

1544:
1545: CURSOR prev_links_cur (cv_to_seq_id number) IS
1546: SELECT from_op_seq_id prev_op, planning_pct
1547: --FROM bom_operation_networks_v
1548: FROM bom_operation_networks
1549: WHERE to_op_seq_id = cv_to_seq_id
1550: AND transition_type <> 3;
1551:
1552: j NUMBER;

Line 1607: FROM bom_operation_networks

1603: ) IS
1604:
1605: CURSOR prev_opns_cur (cv_to_seq_id number) IS
1606: SELECT from_op_seq_id prev_op, planning_pct
1607: FROM bom_operation_networks
1608: WHERE to_op_seq_id = cv_to_seq_id
1609: AND transition_type <> 3;
1610:
1611: j NUMBER;

Line 1653: FROM bom_operation_networks

1649: ) IS
1650:
1651: CURSOR next_opns_cur (cv_to_seq_id number) IS
1652: SELECT to_op_seq_id next_op, planning_pct
1653: FROM bom_operation_networks
1654: WHERE from_op_seq_id = cv_to_seq_id
1655: AND transition_type <> 3;
1656:
1657: j NUMBER;

Line 1695: FROM bom_operation_networks bonv

1691: RETURN BOOLEAN IS
1692: CURSOR prev_ops_cur (cv_op_seq_id number) IS
1693: SELECT from_op_seq_id prev_op_seq_id,
1694: transition_type
1695: FROM bom_operation_networks bonv
1696: --WHERE routing_sequence_id = p_routing_sequence_id
1697: WHERE to_op_seq_id = cv_op_seq_id;
1698: --AND operation_type = p_operation_type;
1699:

Line 1703: FROM bom_operation_networks bonv

1699:
1700: CURSOR next_ops_cur (cv_op_seq_id number) IS
1701: SELECT to_op_seq_id next_op_seq_id,
1702: transition_type
1703: FROM bom_operation_networks bonv
1704: --WHERE routing_sequence_id = p_routing_sequence_id
1705: WHERE from_op_seq_id = cv_op_seq_id;
1706: --AND operation_type = p_operation_type;
1707: rework_in_found BOOLEAN := FALSE;

Line 1743: FROM bom_operation_networks

1739: ) RETURN NUMBER IS
1740:
1741: CURSOR prev_links_cur (cv_to_seq_id number) IS
1742: SELECT from_op_seq_id prev_op, planning_pct
1743: FROM bom_operation_networks
1744: WHERE to_op_seq_id = cv_to_seq_id
1745: AND transition_type = 3;
1746:
1747: j NUMBER;

Line 1769: FROM bom_operation_networks

1765: to_ptr IN NUMBER
1766: ) RETURN BOOLEAN IS
1767: CURSOR feeding_links_cur (cv_to_seq_id number) IS
1768: SELECT from_op_seq_id prev_op, planning_pct
1769: FROM bom_operation_networks
1770: WHERE to_op_seq_id = cv_to_seq_id
1771: AND transition_type <> 3;
1772: CURSOR fed_sum (cv_from_seq_id number) IS
1773: SELECT SUM(planning_pct) pct_sum

Line 1774: FROM bom_operation_networks

1770: WHERE to_op_seq_id = cv_to_seq_id
1771: AND transition_type <> 3;
1772: CURSOR fed_sum (cv_from_seq_id number) IS
1773: SELECT SUM(planning_pct) pct_sum
1774: FROM bom_operation_networks
1775: WHERE from_op_seq_id = cv_from_seq_id
1776: AND transition_type <> 3;
1777: rework_accum NUMBER := 0;
1778: grab_rework BOOLEAN := FALSE;

Line 1810: FROM bom_operation_networks

1806: ,dummy_pct IN NUMBER
1807: ) IS
1808: CURSOR forward_links_cur (cv_from_seq_id number) IS
1809: SELECT to_op_seq_id next_op
1810: FROM bom_operation_networks
1811: WHERE from_op_seq_id = cv_from_seq_id
1812: AND transition_type <> 3;
1813: CURSOR link_percent_cur (cv_from_seq_id number,cv_to_seq_id number) IS
1814: SELECT PLANNING_PCT npp

Line 1815: FROM bom_operation_networks

1811: WHERE from_op_seq_id = cv_from_seq_id
1812: AND transition_type <> 3;
1813: CURSOR link_percent_cur (cv_from_seq_id number,cv_to_seq_id number) IS
1814: SELECT PLANNING_PCT npp
1815: FROM bom_operation_networks
1816: WHERE from_op_seq_id = cv_from_seq_id
1817: AND to_op_seq_id = cv_to_seq_id
1818: AND transition_type <> 3;
1819:

Line 1859: FROM bom_operation_networks

1855: ,dummy_pct IN NUMBER
1856: ) IS
1857: CURSOR forward_links_cur (cv_from_seq_id number) IS
1858: SELECT to_op_seq_id next_op
1859: FROM bom_operation_networks
1860: WHERE from_op_seq_id = cv_from_seq_id
1861: AND transition_type <> 3;
1862: rows_exist number:=0;
1863: j NUMBER;

Line 1893: FROM bom_operation_networks

1889: dummy_plan_percent IN NUMBER
1890: ) IS
1891: CURSOR prev_links_cur (cv_to_seq_id number) IS
1892: SELECT from_op_seq_id prev_op, planning_pct
1893: FROM bom_operation_networks
1894: WHERE to_op_seq_id = cv_to_seq_id
1895: AND transition_type <> 3;
1896:
1897: CURSOR forward_links_cur (cv_from_seq_id number,cv_to_seq_id number) IS

Line 1899: FROM bom_operation_networks

1895: AND transition_type <> 3;
1896:
1897: CURSOR forward_links_cur (cv_from_seq_id number,cv_to_seq_id number) IS
1898: SELECT PLANNING_PCT npp
1899: FROM bom_operation_networks
1900: WHERE from_op_seq_id = cv_from_seq_id
1901: AND to_op_seq_id = cv_to_seq_id
1902: AND transition_type <> 3;
1903:

Line 1974: FROM bom_operation_networks

1970: j number;
1971: l_yield_nppct number;
1972: CURSOR prev_links_cur (cv_to_seq_id number) IS
1973: SELECT from_op_seq_id prev_op, planning_pct
1974: FROM bom_operation_networks
1975: WHERE to_op_seq_id = cv_to_seq_id
1976: AND transition_type <> 3;
1977:
1978: BEGIN

Line 2015: FROM bom_operation_networks

2011: l_count NUMBER := 0;
2012:
2013: CURSOR prev_links_count_cur (cv_to_seq_id number) IS
2014: SELECT count(*) count
2015: FROM bom_operation_networks
2016: WHERE to_op_seq_id = cv_to_seq_id
2017: AND transition_type <> 3;
2018:
2019: CURSOR prev_links_cur (cv_to_seq_id number) IS

Line 2021: FROM bom_operation_networks

2017: AND transition_type <> 3;
2018:
2019: CURSOR prev_links_cur (cv_to_seq_id number) IS
2020: SELECT from_op_seq_id prev_op, planning_pct
2021: FROM bom_operation_networks
2022: WHERE to_op_seq_id = cv_to_seq_id
2023: AND transition_type <> 3;
2024: BEGIN
2025: FOR count_rec in prev_links_count_cur(op_seq_id) LOOP

Line 2056: FROM bom_operation_networks

2052: l_npp number;
2053: j number;
2054: CURSOR rework_out_cur (cv_from_seq_id number) IS
2055: SELECT to_op_seq_id next_op, planning_pct
2056: FROM bom_operation_networks
2057: WHERE from_op_seq_id = cv_from_seq_id
2058: AND transition_type = 3;
2059:
2060: CURSOR next_rework_cur (cv_op_seq_id number) IS

Line 2062: FROM bom_operation_networks

2058: AND transition_type = 3;
2059:
2060: CURSOR next_rework_cur (cv_op_seq_id number) IS
2061: SELECT to_op_seq_id next_op, planning_pct
2062: FROM bom_operation_networks
2063: WHERE from_op_seq_id = cv_op_seq_id
2064: AND transition_type = 3;
2065:
2066: CURSOR next_op_cur (cv_op_seq_id number) IS

Line 2068: FROM bom_operation_networks

2064: AND transition_type = 3;
2065:
2066: CURSOR next_op_cur (cv_op_seq_id number) IS
2067: SELECT to_op_seq_id next_op, planning_pct
2068: FROM bom_operation_networks
2069: WHERE from_op_seq_id = cv_op_seq_id
2070: AND transition_type <> 3;
2071:
2072: CURSOR next_op_cur1 (cv_op_seq_id number) IS

Line 2074: FROM bom_operation_networks

2070: AND transition_type <> 3;
2071:
2072: CURSOR next_op_cur1 (cv_op_seq_id number) IS
2073: SELECT to_op_seq_id next_op, planning_pct
2074: FROM bom_operation_networks
2075: WHERE from_op_seq_id = cv_op_seq_id
2076: AND transition_type <> 3;
2077:
2078: sanity_rework_pct NUMBER ;