APPS.BOMPBXIN dependencies on BOM_SMALL_EXPL_TEMP

Line 14: -- use value from seq bom_small_expl_temp_s |

10: -- Parameters: org_id organization_id |
11: -- order_by 1 - Op seq, item seq |
12: -- 2 - Item seq, op seq |
13: -- grp_id unique value to identify current explosion |
14: -- use value from seq bom_small_expl_temp_s |
15: -- levels_to_explode |
16: -- bom_or_eng 1 - BOM |
17: -- 2 - ENG |
18: -- impl_flag 1 - implemented only |

Line 242: FROM BOM_SMALL_EXPL_TEMP BET, BOM_BILL_OF_MATERIALS BOM,

238: BIC.ATTRIBUTE12,
239: BIC.ATTRIBUTE13,
240: BIC.ATTRIBUTE14,
241: BIC.ATTRIBUTE15
242: FROM BOM_SMALL_EXPL_TEMP BET, BOM_BILL_OF_MATERIALS BOM,
243: MTL_SYSTEM_ITEMS SI,
244: BOM_INVENTORY_COMPONENTS BIC
245: WHERE BET.PLAN_LEVEL = c_level - 1
246: AND BET.GROUP_ID = c_grp_id

Line 458: bom_small_expl_temp bet

454: Select msi.concatenated_segments,
455: bom.alternate_bom_designator
456: From mtl_system_items_kfv msi,
457: bom_bill_of_materials bom,
458: bom_small_expl_temp bet
459: Where msi.inventory_item_id = bom.assembly_item_id
460: And msi.organization_id = bom.organization_id
461: And bom.bill_sequence_id = bet.top_bill_sequence_id
462: And bet.group_id = grp_id

Line 769: -- BOM_SMALL_EXPL_TEMP table #1409015.

765: l_Operation_Offset(i) := X_Item.offset;
766: End loop;
767: End if; -- operation offset
768: -- Inserting the Flex field values ATTRIBUTE1-ATTRIBUTE15 also in the
769: -- BOM_SMALL_EXPL_TEMP table #1409015.
770:
771: end loop; -- cursor fetch loop
772:
773: FORALL i IN 1..loop_count_val

Line 775: INSERT INTO BOM_SMALL_EXPL_TEMP (

771: end loop; -- cursor fetch loop
772:
773: FORALL i IN 1..loop_count_val
774:
775: INSERT INTO BOM_SMALL_EXPL_TEMP (
776: TOP_BILL_SEQUENCE_ID,
777: BILL_SEQUENCE_ID,
778: COMMON_BILL_SEQUENCE_ID,
779: ORGANIZATION_ID,