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 181: -- Added Hint BOM_SMALL_EXPL_TEMP_N1 for bug#16236052

177: c_plan_factor_flag NUMBER,
178: c_std_comp_flag NUMBER,
179: c_incl_oc NUMBER
180: ) IS
181: -- Added Hint BOM_SMALL_EXPL_TEMP_N1 for bug#16236052
182: SELECT /*+ INDEX(BET BOM_SMALL_EXPL_TEMP_N1) */
183: BET.TOP_BILL_SEQUENCE_ID TBSI,
184: BOM.BILL_SEQUENCE_ID BSI,
185: BOM.COMMON_BILL_SEQUENCE_ID CBSI,

Line 182: SELECT /*+ INDEX(BET BOM_SMALL_EXPL_TEMP_N1) */

178: c_std_comp_flag NUMBER,
179: c_incl_oc NUMBER
180: ) IS
181: -- Added Hint BOM_SMALL_EXPL_TEMP_N1 for bug#16236052
182: SELECT /*+ INDEX(BET BOM_SMALL_EXPL_TEMP_N1) */
183: BET.TOP_BILL_SEQUENCE_ID TBSI,
184: BOM.BILL_SEQUENCE_ID BSI,
185: BOM.COMMON_BILL_SEQUENCE_ID CBSI,
186: BIC.COMPONENT_ITEM_ID CID,

Line 246: FROM BOM_SMALL_EXPL_TEMP BET, BOM_BILL_OF_MATERIALS BOM,

242: BIC.ATTRIBUTE12,
243: BIC.ATTRIBUTE13,
244: BIC.ATTRIBUTE14,
245: BIC.ATTRIBUTE15
246: FROM BOM_SMALL_EXPL_TEMP BET, BOM_BILL_OF_MATERIALS BOM,
247: MTL_SYSTEM_ITEMS SI,
248: BOM_INVENTORY_COMPONENTS BIC
249: WHERE BET.PLAN_LEVEL = c_level - 1
250: AND BET.GROUP_ID = c_grp_id

Line 462: bom_small_expl_temp bet

458: Select msi.concatenated_segments,
459: bom.alternate_bom_designator
460: From mtl_system_items_kfv msi,
461: bom_bill_of_materials bom,
462: bom_small_expl_temp bet
463: Where msi.inventory_item_id = bom.assembly_item_id
464: And msi.organization_id = bom.organization_id
465: And bom.bill_sequence_id = bet.top_bill_sequence_id
466: And bet.group_id = grp_id

Line 786: -- BOM_SMALL_EXPL_TEMP table #1409015.

782: l_Operation_Offset(i) := X_Item.offset;
783: End loop;
784: End if; -- operation offset
785: -- Inserting the Flex field values ATTRIBUTE1-ATTRIBUTE15 also in the
786: -- BOM_SMALL_EXPL_TEMP table #1409015.
787:
788: end loop; -- cursor fetch loop
789:
790: -- Added to fix bug 9355186

Line 797: INSERT INTO BOM_SMALL_EXPL_TEMP (

793: End if;
794:
795: FORALL i IN 1..loop_count_val
796:
797: INSERT INTO BOM_SMALL_EXPL_TEMP (
798: TOP_BILL_SEQUENCE_ID,
799: BILL_SEQUENCE_ID,
800: COMMON_BILL_SEQUENCE_ID,
801: ORGANIZATION_ID,

Line 957: update BOM_SMALL_EXPL_TEMP BSET

953:
954: /* Bug: 9355186
955: Moved the revision specific code outside the loop for performance issues */
956: If show_rev = 1 then
957: update BOM_SMALL_EXPL_TEMP BSET
958: set CURRENT_REVISION =
959: (select MAX(MIR.revision)
960: FROM MTL_ITEM_REVISIONS_B MIR
961: where INVENTORY_ITEM_ID = BSET.COMPONENT_ITEM_ID