eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1408: FROM BOM_BILL_OF_MATERIALS

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

Line 1605: FROM BOM_BILL_OF_MATERIALS

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

Line 2311: FROM BOM_BILL_OF_MATERIALS

2307: BEGIN
2308:
2309: select 1
2310: INTO l_alternate_bom
2311: FROM BOM_BILL_OF_MATERIALS
2312: WHERE assembly_item_id = ri.revised_item_id
2313: AND organization_id = l_org_id
2314: AND alternate_bom_designator is NULL;
2315:

Line 2500: from bom_bill_of_materials

2496: BEGIN
2497: St_Number := 10;
2498: select assembly_item_id
2499: into item_id
2500: from bom_bill_of_materials
2501: where bill_sequence_id = rcd.bill_sequence_id;
2502: /* for bug 9368374 */
2503: St_Number := 15;
2504: select alternate_bom_designator

Line 2506: from bom_bill_of_materials

2502: /* for bug 9368374 */
2503: St_Number := 15;
2504: select alternate_bom_designator
2505: into l_alternate_bom
2506: from bom_bill_of_materials
2507: where bill_sequence_id = rcd.bill_sequence_id;
2508: /* for bug 9368374 */
2509: St_Number := 20;
2510: select bill_sequence_id

Line 2512: from bom_bill_of_materials

2508: /* for bug 9368374 */
2509: St_Number := 20;
2510: select bill_sequence_id
2511: into bill_id
2512: from bom_bill_of_materials
2513: where assembly_item_id = item_id
2514: and organization_id = l_org_id
2515: and NVL(alternate_bom_designator,'-999')= NVL(l_alternate_bom,'-999'); /* for bug 9368374 */
2516:

Line 2766: from bom_bill_of_materials

2762: /* for bug 9368374 */
2763: BEGIN
2764: select alternate_bom_designator
2765: into l_alternate_bom
2766: from bom_bill_of_materials
2767: where bill_sequence_id = rc.bill_sequence_id;
2768:
2769: EXCEPTION WHEN NO_DATA_FOUND THEN
2770: l_check_invalid_objects := 0;

Line 2778: from bom_bill_of_materials

2774: BEGIN
2775: St_Number := 10;
2776: select assembly_item_id
2777: into item_id
2778: from bom_bill_of_materials
2779: where bill_sequence_id = rc.bill_sequence_id;
2780:
2781: St_Number := 20;
2782: select bill_sequence_id

Line 2784: from bom_bill_of_materials

2780:
2781: St_Number := 20;
2782: select bill_sequence_id
2783: into bill_id
2784: from bom_bill_of_materials
2785: where assembly_item_id = item_id
2786: and organization_id = l_org_id
2787: and NVL(alternate_bom_designator,'-999') = NVL(l_alternate_bom,'-999'); /* for bug 9368374 */
2788:

Line 3646: from bom_bill_of_materials

3642: BEGIN
3643: St_Number := 10;
3644: select assembly_item_id
3645: into item_id
3646: from bom_bill_of_materials
3647: where bill_sequence_id = rc.bill_sequence_id;
3648:
3649: St_Number := 20;
3650: select bill_sequence_id

Line 3652: from bom_bill_of_materials

3648:
3649: St_Number := 20;
3650: select bill_sequence_id
3651: into bill_id
3652: from bom_bill_of_materials
3653: where assembly_item_id = item_id
3654: and organization_id = p_local_organization_id
3655: and nvl(ALTERNATE_BOM_DESIGNATOR, 'primary') = nvl(p_revised_item_rec.alternate_bom_code,'primary');
3656:

Line 5161: FROM BOM_BILL_OF_MATERIALS

5157: IF (ri.CURRENT_STRUCTURE_REV_ID IS NOT NULL)
5158: THEN
5159: select bill_sequence_id
5160: into l_local_bill_sequence_id
5161: FROM BOM_BILL_OF_MATERIALS
5162: WHERE assembly_item_id = ri.revised_item_id
5163: AND organization_id = p_local_organization_id
5164: AND nvl(alternate_bom_designator, 'PRIMARY') = nvl(ri.alternate_bom_designator, 'PRIMARY');
5165:

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

5222: IF (ri.from_end_item_strc_rev_id IS NOT NULL)
5223: THEN
5224: select bsr.revision, bbm.alternate_bom_designator
5225: into l_from_end_item_minor_rev, l_from_end_item_alternate
5226: from should use minor revision table bsr, bom_bill_of_materials bbm
5227: where bsr.structure_revision_id = ri.from_end_item_strc_rev_id
5228: and bsr.bill_sequence_id = bbm.bill_sequence_id;
5229: END IF;*/
5230: