APPS.BOMPEXPL dependencies on BOM_EXPLOSION_TEMP

Line 19: | use value from sequence bom_explosion_temp_s

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

Line 21: | use value from bom_explosion_temp_session_s

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

Line 291: FROM BOM_EXPLOSION_TEMP BET, BOM_BILL_OF_MATERIALS BOM,

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

Line 564: BOM_EXPLOSION_TEMP bet

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

Line 994: INSERT INTO bom_explosion_temp

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 ,

Line 1143: UPDATE bom_explosion_temp

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: */

Line 1390: insert into bom_explosion_temp(

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,

Line 1495: insert into bom_explosion_temp(

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,

Line 1783: FROM BOM_EXPLOSION_TEMP

1779:
1780: CURSOR loop_flag_rows ( c_group_id NUMBER )
1781: IS
1782: SELECT SORT_ORDER
1783: FROM BOM_EXPLOSION_TEMP
1784: WHERE
1785: LOOP_FLAG = 1
1786: AND GROUP_ID = c_group_id;
1787:

Line 1829: INSERT INTO BOM_EXPLOSION_TEMP

1825: IF (module = 1 or module = 4) THEN /* CST */
1826:
1827: stmt_num := 3;
1828:
1829: INSERT INTO BOM_EXPLOSION_TEMP
1830: (
1831: GROUP_ID,
1832: BILL_SEQUENCE_ID,
1833: COMPONENT_SEQUENCE_ID,

Line 1933: UPDATE BOM_EXPLOSION_TEMP bet_update

1929: --bug:5362238 For Loop Report, propage loop flag up the hierarchy.
1930: IF ( verify_flag = 1 ) THEN
1931: FOR l_loop_flag_row_rec IN loop_flag_rows( grp_id )
1932: LOOP
1933: UPDATE BOM_EXPLOSION_TEMP bet_update
1934: SET bet_update.LOOP_FLAG = 1
1935: WHERE bet_update.SORT_ORDER IN
1936: ( SELECT bet.SORT_ORDER
1937: FROM BOM_EXPLOSION_TEMP bet

Line 1937: FROM BOM_EXPLOSION_TEMP bet

1933: UPDATE BOM_EXPLOSION_TEMP bet_update
1934: SET bet_update.LOOP_FLAG = 1
1935: WHERE bet_update.SORT_ORDER IN
1936: ( SELECT bet.SORT_ORDER
1937: FROM BOM_EXPLOSION_TEMP bet
1938: WHERE
1939: bet.GROUP_ID = grp_id
1940: CONNECT BY PRIOR
1941: SubStr( bet.SORT_ORDER, 1, (bet.PLAN_LEVEL * 7) ) = bet.SORT_ORDER

Line 1987: FROM BOM_EXPLOSION_TEMP

1983: CREATION_DATE, CREATED_BY)
1984:
1985: SELECT cst_rlp_id, COMPONENT_ITEM_ID, max(PLAN_LEVEL),
1986: sysdate, user_id, sysdate, user_id
1987: FROM BOM_EXPLOSION_TEMP
1988: WHERE GROUP_ID = grp_id
1989: GROUP BY COMPONENT_ITEM_ID;
1990:
1991: /*