[Home] [Help]
15: | Parameters: org_id organization_id
16: | order_by 1 - Op seq, item seq
17: | 2 - Item seq, op seq
18: | grp_id unique value to identify current explosion
19: | use value from sequence bom_explosion_temp_s
20: | session_id unique value to identify current session
21: | use value from bom_explosion_temp_session_s
22: | levels_to_explode
23: | bom_or_eng 1 - BOM
17: | 2 - Item seq, op seq
18: | grp_id unique value to identify current explosion
19: | use value from sequence bom_explosion_temp_s
20: | session_id unique value to identify current session
21: | use value from bom_explosion_temp_session_s
22: | levels_to_explode
23: | bom_or_eng 1 - BOM
24: | 2 - ENG
25: | impl_flag 1 - implemented only
287: BIC.ATTRIBUTE14,
288: BIC.ATTRIBUTE15,
289: BET.SORT_ORDER PARENT_SORT_ORDER,
290: BIC.AUTO_REQUEST_MATERIAL
291: FROM BOM_EXPLOSION_TEMP BET, BOM_BILL_OF_MATERIALS BOM,
292: MTL_SYSTEM_ITEMS_B SI,
293: BOM_INVENTORY_COMPONENTS BIC,
294: ENG_REVISED_ITEMS ERI
295: WHERE BET.PLAN_LEVEL = c_level - 1
560: Select msi.concatenated_segments,
561: bom.alternate_bom_designator
562: From mtl_system_items_b_kfv msi,
563: bom_bill_of_materials bom,
564: BOM_EXPLOSION_TEMP bet
565: Where msi.inventory_item_id = bom.assembly_item_id
566: And msi.organization_id = bom.organization_id
567: And bom.bill_sequence_id = bet.top_bill_sequence_id
568: And bet.group_id = grp_id
990:
991: --dbms_output.put_line('O.K. enough. insert now');
992:
993: FORALL i IN 1..top_bill_sequence_id_tbl.COUNT
994: INSERT INTO bom_explosion_temp
995: (
996: TOP_BILL_SEQUENCE_ID ,
997: BILL_SEQUENCE_ID ,
998: COMMON_BILL_SEQUENCE_ID ,
1139: /* Update the quantity of children for every parent, total quantity for every parent */
1140:
1141: /*
1142: FORALL i IN 1..g_parent_sort_order_tbl.COUNT
1143: UPDATE bom_explosion_temp
1144: SET quantity_of_children = g_quantity_of_children_tbl(i),
1145: total_qty_at_next_level = g_total_qty_at_next_level_tbl(i)
1146: WHERE group_id = grp_id AND sort_order = g_parent_sort_order_tbl(i);
1147: */
1386: l_err_msg := null;
1387: l_error_code := 0;
1388:
1389:
1390: insert into bom_explosion_temp(
1391: group_id,
1392: bill_sequence_id,
1393: common_bill_sequence_id,
1394: component_sequence_id,
1491:
1492: For l_list_rec in l_list_csr
1493: loop
1494:
1495: insert into bom_explosion_temp(
1496: group_id,
1497: bill_sequence_id,
1498: common_bill_sequence_id,
1499: component_sequence_id,
1787: --
1788: CURSOR loop_flag_rows ( c_group_id NUMBER )
1789: IS
1790: SELECT SORT_ORDER, top_bill_sequence_id
1791: FROM BOM_EXPLOSION_TEMP
1792: WHERE
1793: LOOP_FLAG = 1
1794: AND GROUP_ID = c_group_id;
1795:
1835: IF (module = 1 or module = 4) THEN /* CST */
1836:
1837: stmt_num := 3;
1838:
1839: INSERT INTO BOM_EXPLOSION_TEMP
1840: (
1841: GROUP_ID,
1842: BILL_SEQUENCE_ID,
1843: COMPONENT_SEQUENCE_ID,
1940: --bug:5362238 For Loop Report, propage loop flag up the hierarchy.
1941: IF ( verify_flag = 1 ) THEN
1942: FOR l_loop_flag_row_rec IN loop_flag_rows( grp_id )
1943: LOOP
1944: UPDATE BOM_EXPLOSION_TEMP bet_update
1945: SET bet_update.LOOP_FLAG = 1
1946: WHERE (bet_update.SORT_ORDER, bet_update.top_bill_sequence_id) IN
1947: ( SELECT bet.SORT_ORDER, bet.top_bill_sequence_id -- bug 13473719
1948: FROM BOM_EXPLOSION_TEMP bet
1944: UPDATE BOM_EXPLOSION_TEMP bet_update
1945: SET bet_update.LOOP_FLAG = 1
1946: WHERE (bet_update.SORT_ORDER, bet_update.top_bill_sequence_id) IN
1947: ( SELECT bet.SORT_ORDER, bet.top_bill_sequence_id -- bug 13473719
1948: FROM BOM_EXPLOSION_TEMP bet
1949: WHERE
1950: bet.GROUP_ID = grp_id
1951: --
1952: -- bug 13473719
2004: CREATION_DATE, CREATED_BY)
2005:
2006: SELECT cst_rlp_id, COMPONENT_ITEM_ID, max(PLAN_LEVEL),
2007: sysdate, user_id, sysdate, user_id
2008: FROM BOM_EXPLOSION_TEMP
2009: WHERE GROUP_ID = grp_id
2010: GROUP BY COMPONENT_ITEM_ID;
2011:
2012: /*