APPS.ENGECOBO dependencies on BOM_BILL_OF_MATERIALS

Line 572: /* update the commoned information in bom_bill_of_materials */

568: , eco_unit_number => NULL
569: , unit_number => NULL
570: , from_item_id => p_from_item_id
571: );
572: /* update the commoned information in bom_bill_of_materials */
573: update bom_bill_of_materials set
574: common_bill_sequence_id = p_to_sequence_id,
575: common_organization_id = NULL,
576: common_assembly_item_id = NULL

Line 573: update bom_bill_of_materials set

569: , unit_number => NULL
570: , from_item_id => p_from_item_id
571: );
572: /* update the commoned information in bom_bill_of_materials */
573: update bom_bill_of_materials set
574: common_bill_sequence_id = p_to_sequence_id,
575: common_organization_id = NULL,
576: common_assembly_item_id = NULL
577: where bill_sequence_id = p_to_sequence_id;

Line 1405: FROM BOM_BILL_OF_MATERIALS

1401: l_structure_exists_flag := 1;
1402: BEGIN
1403: select bill_sequence_id, source_bill_sequence_id
1404: into l_local_bill_sequence_id, l_comn_bill_sequence_id
1405: FROM BOM_BILL_OF_MATERIALS
1406: WHERE assembly_item_id = sl.revised_item_id
1407: AND organization_id = p_local_org_id
1408: AND nvl(alternate_bom_designator, 'PRIMARY') = nvl(sl.alternate_bom_designator, 'PRIMARY');
1409: EXCEPTION

Line 1602: FROM BOM_BILL_OF_MATERIALS

1598: BEGIN
1599: l_structure_exists_flag := 1;
1600: select bill_sequence_id, common_bill_sequence_id, assembly_type
1601: into l_local_bill_sequence_id, l_comn_bill_sequence_id, l_eng_bill_flag
1602: FROM BOM_BILL_OF_MATERIALS
1603: WHERE assembly_item_id = tolc.revised_item_id
1604: AND organization_id = p_local_org_id
1605: AND nvl(alternate_bom_designator, 'PRIMARY') = nvl(tolc.alternate_bom_designator, 'PRIMARY');
1606: EXCEPTION

Line 2449: from bom_bill_of_materials

2445: BEGIN
2446: St_Number := 10;
2447: select assembly_item_id
2448: into item_id
2449: from bom_bill_of_materials
2450: where bill_sequence_id = rcd.bill_sequence_id;
2451:
2452: St_Number := 20;
2453: select bill_sequence_id

Line 2455: from bom_bill_of_materials

2451:
2452: St_Number := 20;
2453: select bill_sequence_id
2454: into bill_id
2455: from bom_bill_of_materials
2456: where assembly_item_id = item_id
2457: and organization_id = l_org_id
2458: and ALTERNATE_BOM_DESIGNATOR IS NULL;
2459:

Line 2710: from bom_bill_of_materials

2706: BEGIN
2707: St_Number := 10;
2708: select assembly_item_id
2709: into item_id
2710: from bom_bill_of_materials
2711: where bill_sequence_id = rc.bill_sequence_id;
2712:
2713: St_Number := 20;
2714: select bill_sequence_id

Line 2716: from bom_bill_of_materials

2712:
2713: St_Number := 20;
2714: select bill_sequence_id
2715: into bill_id
2716: from bom_bill_of_materials
2717: where assembly_item_id = item_id
2718: and organization_id = l_org_id
2719: and ALTERNATE_BOM_DESIGNATOR IS NULL;
2720:

Line 3521: from bom_bill_of_materials

3517: BEGIN
3518: St_Number := 10;
3519: select assembly_item_id
3520: into item_id
3521: from bom_bill_of_materials
3522: where bill_sequence_id = rc.bill_sequence_id;
3523:
3524: St_Number := 20;
3525: select bill_sequence_id

Line 3527: from bom_bill_of_materials

3523:
3524: St_Number := 20;
3525: select bill_sequence_id
3526: into bill_id
3527: from bom_bill_of_materials
3528: where assembly_item_id = item_id
3529: and organization_id = p_local_organization_id
3530: and nvl(ALTERNATE_BOM_DESIGNATOR, 'primary') = nvl(p_revised_item_rec.alternate_bom_code,'primary');
3531:

Line 5034: FROM BOM_BILL_OF_MATERIALS

5030: IF (ri.CURRENT_STRUCTURE_REV_ID IS NOT NULL)
5031: THEN
5032: select bill_sequence_id
5033: into l_local_bill_sequence_id
5034: FROM BOM_BILL_OF_MATERIALS
5035: WHERE assembly_item_id = ri.revised_item_id
5036: AND organization_id = p_local_organization_id
5037: AND nvl(alternate_bom_designator, 'PRIMARY') = nvl(ri.alternate_bom_designator, 'PRIMARY');
5038:

Line 5099: from should use minor revision table bsr, bom_bill_of_materials bbm

5095: IF (ri.from_end_item_strc_rev_id IS NOT NULL)
5096: THEN
5097: select bsr.revision, bbm.alternate_bom_designator
5098: into l_from_end_item_minor_rev, l_from_end_item_alternate
5099: from should use minor revision table bsr, bom_bill_of_materials bbm
5100: where bsr.structure_revision_id = ri.from_end_item_strc_rev_id
5101: and bsr.bill_sequence_id = bbm.bill_sequence_id;
5102: END IF;*/
5103: