APPS.BOM_BOM_COMPONENT_UTIL dependencies on BOM_INVENTORY_COMPONENTS

Line 351: FROM BOM_INVENTORY_COMPONENTS

347: , l_rev_component_rec.Suggested_Vendor_Name --- Deepu
348: -- , l_rev_component_rec.purchasing_category_id --- Deepu
349: , l_rev_comp_unexp_rec.Vendor_Id --- Deepu
350: , l_rev_component_rec.Unit_Price --- Deepu
351: FROM BOM_INVENTORY_COMPONENTS
352: WHERE component_item_id = p_component_item_id
353: AND effectivity_date = p_effectivity_date
354: AND operation_seq_num = nvl(p_operation_sequence_number,1) --Bug 5856042
355: AND bill_sequence_id = p_bill_sequence_id

Line 462: UPDATE BOM_INVENTORY_COMPONENTS

458:
459: END IF;
460:
461:
462: UPDATE BOM_INVENTORY_COMPONENTS
463: SET SUPPLY_SUBINVENTORY = p_rev_component_rec.supply_subinventory
464: , REQUIRED_FOR_REVENUE = p_rev_component_rec.required_for_revenue
465: , HIGH_QUANTITY = p_rev_component_rec.maximum_allowed_quantity
466: , WIP_SUPPLY_TYPE = p_rev_component_rec.wip_supply_type

Line 657: -- moved the select from bom_inventory_components in this block for bug 7713832

653: -- bug 2820641
654: -- BOM form : BOMFDBOM.fmb won't insert the Old_component_sequence_id.
655: -- ENG form : ENGFDECN.fmb will always inserts Old_component_sequence_id.
656:
657: -- moved the select from bom_inventory_components in this block for bug 7713832
658: -- This was originally in the insert statement
659: -- It was removed so that while migrating common bill components
660: --common_component_sequence_id is populated correctly
661:

Line 671: Select common_component_sequence_id into l_src_comp_seq_id from bom_inventory_components where

667: else
668: l_old_component_sequence_id := p_rev_comp_Unexp_rec.old_component_sequence_id;
669: --these 2 values will always be the same for acd_type 1
670: if l_old_component_sequence_id <> p_rev_comp_Unexp_rec.component_sequence_id then
671: Select common_component_sequence_id into l_src_comp_seq_id from bom_inventory_components where
672: component_sequence_id = l_old_component_sequence_id;
673: end if;
674: end if;
675: else

Line 681: Select common_component_sequence_id into l_src_comp_seq_id from bom_inventory_components where

677: l_old_component_sequence_id := NULL;
678: else
679: l_old_component_sequence_id := p_rev_comp_Unexp_rec.old_component_sequence_id;
680: if l_old_component_sequence_id is not null then
681: Select common_component_sequence_id into l_src_comp_seq_id from bom_inventory_components where
682: component_sequence_id = l_old_component_sequence_id;
683: end if;
684:
685: end if;

Line 740: INSERT INTO BOM_INVENTORY_COMPONENTS

736: END IF;
737:
738: --Bug 7712832 changes end
739: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
740: INSERT INTO BOM_INVENTORY_COMPONENTS
741: ( SUPPLY_SUBINVENTORY
742: , OPERATION_LEAD_TIME_PERCENT
743: , REVISED_ITEM_SEQUENCE_ID
744: , COST_FACTOR

Line 1060: DELETE FROM BOM_INVENTORY_COMPONENTS

1056:
1057: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
1058: THEN
1059:
1060: DELETE FROM BOM_INVENTORY_COMPONENTS
1061: WHERE COMPONENT_SEQUENCE_ID = p_rev_comp_unexp_rec.component_sequence_id;
1062: -- p_component_sequence_id ;
1063:
1064: /******************************************************************

Line 1309: FROM BOM_INVENTORY_COMPONENTS IC

1305: IC.ATTRIBUTE12,
1306: IC.ATTRIBUTE13,
1307: IC.ATTRIBUTE14,
1308: IC.ATTRIBUTE15
1309: FROM BOM_INVENTORY_COMPONENTS IC
1310: WHERE IC.COMPONENT_SEQUENCE_ID = comp_seq_id;
1311: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows inserted into erc');
1312:
1313: /*

Line 1316: DELETE FROM BOM_INVENTORY_COMPONENTS

1312:
1313: /*
1314: ** delete from bom_inventory_comps
1315: */
1316: DELETE FROM BOM_INVENTORY_COMPONENTS
1317: WHERE COMPONENT_SEQUENCE_ID = comp_seq_id;
1318: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows delete from bic');
1319:
1320: -- Fixed bug 618781.

Line 1409: SELECT bom_inventory_components_s.nextval bill_sequence_id

1405: 'NONE')
1406: );
1407: l_bill_sequence_id NUMBER;
1408: CURSOR GetBillSeqId IS
1409: SELECT bom_inventory_components_s.nextval bill_sequence_id
1410: FROM sys.dual;
1411:
1412: err_text varchar2(2000);
1413: err_code varchar2(100);

Line 1589: FROM bom_inventory_components

1585: -- Fetch Component Sequence Id
1586: --
1587: SELECT component_sequence_id
1588: INTO l_comp_seq_id
1589: FROM bom_inventory_components
1590: WHERE component_item_id =
1591: l_rev_comp_unexp_rec.component_item_id
1592: AND bill_sequence_id = l_rev_comp_unexp_rec.bill_sequence_id
1593: AND operation_seq_num =