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 672: INSERT INTO BOM_INVENTORY_COMPONENTS

668:
669: END IF;
670:
671: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
672: INSERT INTO BOM_INVENTORY_COMPONENTS
673: ( SUPPLY_SUBINVENTORY
674: , OPERATION_LEAD_TIME_PERCENT
675: , REVISED_ITEM_SEQUENCE_ID
676: , COST_FACTOR

Line 865: ,(Select common_component_sequence_id from bom_inventory_components where

861: ,l_object_revision_id
862: ,l_minor_revision_id
863: --,l_comp_revision_id
864: --,l_comp_minor_revision_id
865: ,(Select common_component_sequence_id from bom_inventory_components where
866: component_sequence_id = l_old_component_sequence_id)
867: );
868: --For non-referencing common boms.
869: BOMPCMBM.Insert_Related_Components( p_src_bill_seq_id => p_rev_comp_Unexp_rec.bill_sequence_id

Line 958: DELETE FROM BOM_INVENTORY_COMPONENTS

954:
955: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
956: THEN
957:
958: DELETE FROM BOM_INVENTORY_COMPONENTS
959: WHERE COMPONENT_SEQUENCE_ID = p_rev_comp_unexp_rec.component_sequence_id;
960: -- p_component_sequence_id ;
961:
962: /******************************************************************

Line 1202: FROM BOM_INVENTORY_COMPONENTS IC

1198: IC.ATTRIBUTE12,
1199: IC.ATTRIBUTE13,
1200: IC.ATTRIBUTE14,
1201: IC.ATTRIBUTE15
1202: FROM BOM_INVENTORY_COMPONENTS IC
1203: WHERE IC.COMPONENT_SEQUENCE_ID = comp_seq_id;
1204: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows inserted into erc');
1205:
1206: /*

Line 1209: DELETE FROM BOM_INVENTORY_COMPONENTS

1205:
1206: /*
1207: ** delete from bom_inventory_comps
1208: */
1209: DELETE FROM BOM_INVENTORY_COMPONENTS
1210: WHERE COMPONENT_SEQUENCE_ID = comp_seq_id;
1211: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows delete from bic');
1212:
1213: -- Fixed bug 618781.

Line 1302: SELECT bom_inventory_components_s.nextval bill_sequence_id

1298: 'NONE')
1299: );
1300: l_bill_sequence_id NUMBER;
1301: CURSOR GetBillSeqId IS
1302: SELECT bom_inventory_components_s.nextval bill_sequence_id
1303: FROM sys.dual;
1304:
1305: err_text varchar2(2000);
1306: err_code varchar2(100);

Line 1482: FROM bom_inventory_components

1478: -- Fetch Component Sequence Id
1479: --
1480: SELECT component_sequence_id
1481: INTO l_comp_seq_id
1482: FROM bom_inventory_components
1483: WHERE component_item_id =
1484: l_rev_comp_unexp_rec.component_item_id
1485: AND bill_sequence_id = l_rev_comp_unexp_rec.bill_sequence_id
1486: AND operation_seq_num =