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.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_BILL_OF_MATERIALS

Line 1476: FROM bom_bill_of_materials

1472: BEGIN
1473: -- If Phantom then Component must be a Bill
1474: SELECT 'Valid'
1475: INTO l_dummy
1476: FROM bom_bill_of_materials
1477: WHERE assembly_item_id =
1478: g_rev_comp_unexp_rec.component_item_id
1479: AND organization_id =
1480: g_rev_comp_unexp_rec.organization_id

Line 1972: FROM bom_bill_of_materials

1968: l_alternate_bom_designator VARCHAR2(10) := NULL;
1969:
1970: CURSOR GetAlternate IS
1971: SELECT alternate_bom_designator
1972: FROM bom_bill_of_materials
1973: WHERE bill_sequence_id = g_rev_comp_unexp_rec.bill_sequence_id;
1974:
1975: CURSOR CheckRouting IS
1976: SELECT 'x'

Line 2393: FROM BOM_BILL_OF_MATERIALS bom

2389: l_invalid_bill NUMBER;
2390: l_allow_eng_comps varchar2(10) := nvl(fnd_profile.value('ENG:ALLOW_ENG_COMPS'), '2'); -- Bug 6274872
2391: CURSOR bom_enabled_in_other_orgs IS
2392: SELECT 1
2393: FROM BOM_BILL_OF_MATERIALS bom
2394: WHERE bom.source_bill_sequence_id =
2395: g_rev_comp_Unexp_rec.bill_sequence_id
2396: AND bom.organization_id <>
2397: g_rev_comp_Unexp_rec.organization_id

Line 2409: FROM BOM_BILL_OF_MATERIALS bom

2405: );
2406:
2407: CURSOR in_other_orgs IS
2408: SELECT 1
2409: FROM BOM_BILL_OF_MATERIALS bom
2410: WHERE bom.source_bill_sequence_id =
2411: g_rev_comp_Unexp_rec.bill_sequence_id
2412: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
2413: AND NOT EXISTS (SELECT 1

Line 2423: FROM BOM_BILL_OF_MATERIALS bom

2419:
2420: CURSOR eng_flag_in_other_orgs
2421: IS
2422: SELECT 1
2423: FROM BOM_BILL_OF_MATERIALS bom
2424: WHERE bom.source_bill_sequence_id =
2425: g_rev_comp_Unexp_rec.bill_sequence_id
2426: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
2427: AND NOT EXISTS (SELECT 1

Line 2444: FROM BOM_BILL_OF_MATERIALS

2440:
2441: /*Cursor editable_common_bom_other_org
2442: IS
2443: SELECT bill_Sequence_id
2444: FROM BOM_BILL_OF_MATERIALS
2445: WHERE common_bill_Sequence_id <> source_bill_sequence_id
2446: AND source_bill_sequence_id = g_rev_comp_Unexp_rec.bill_sequence_id
2447: AND organization_id <> g_rev_comp_Unexp_rec.organization_id;
2448:

Line 2452: FROM BOM_OPERATION_SEQUENCES bos, BOM_OPERATIONAL_ROUTINGS bor, BOM_BILL_OF_MATERIALS bom

2448:
2449: Cursor valid_op_seq(p_bill_seq_id NUMBER)
2450: IS
2451: SELECT 1
2452: FROM BOM_OPERATION_SEQUENCES bos, BOM_OPERATIONAL_ROUTINGS bor, BOM_BILL_OF_MATERIALS bom
2453: WHERE (bor.routing_sequence_id = bos.routing_sequence_id
2454: AND bor.assembly_item_id = bom.assembly_item_id
2455: AND bor.organization_id = bom.organization_id
2456: AND nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')

Line 2509: FROM bom_bill_of_materials

2505: RETURN BOOLEAN
2506: IS
2507: CURSOR c_CheckPrimary IS
2508: SELECT 1
2509: FROM bom_bill_of_materials
2510: WHERE assembly_item_id = g_Rev_Comp_Unexp_Rec.revised_item_id
2511: AND organization_id = g_Rev_Comp_Unexp_Rec.Organization_Id
2512: AND NVL(alternate_bom_designator, 'NONE') = 'NONE';
2513: BEGIN

Line 2550: FROM bom_bill_of_materials

2546: , p_organization_id NUMBER)
2547: IS
2548:
2549: SELECT 1
2550: FROM bom_bill_of_materials
2551: WHERE assembly_item_id = p_revied_item_id
2552: AND organization_id = p_organization_id
2553: AND NVL(alternate_bom_designator, 'NONE') = 'NONE';
2554:

Line 2906: FROM BOM_BILL_OF_MATERIALS

2902: IS
2903: l_deref_bom varchar2(1);
2904: BEGIN
2905: SELECT 'Y' into l_deref_bom
2906: FROM BOM_BILL_OF_MATERIALS
2907: WHERE bill_sequence_id = common_bill_sequence_id
2908: AND bill_sequence_id <> nvl(source_bill_sequence_id, common_bill_sequence_id)
2909: AND bill_sequence_id = p_bill_sequence_id;
2910: IF l_deref_bom = 'Y' THEN

Line 3070: FROM bom_bill_of_materials bom

3066: WHERE eri.revised_item_sequence_id =
3067: p_rev_comp_Unexp_rec.revised_item_sequence_id
3068: AND eri.bill_sequence_id IS NULL
3069: AND NOT EXISTS (SELECT 1
3070: FROM bom_bill_of_materials bom
3071: WHERE bom.bill_sequence_id =
3072: p_rev_comp_Unexp_rec.bill_sequence_id
3073: );
3074:

Line 3300: from bom_bill_of_materials

3296: select assembly_type
3297: into g_Assy_Assembly_Type
3298: --bug: 4161794. Introduced new global variable to hold value of assembly type
3299: -- of the header.
3300: from bom_bill_of_materials
3301: where bill_sequence_id = p_rev_comp_Unexp_rec.bill_sequence_id;
3302: END IF;
3303:
3304: --

Line 3580: FROM bom_bill_of_materials bom

3576: -- bill as common
3577: BEGIN
3578: SELECT 'Valid'
3579: INTO l_dummy
3580: FROM bom_bill_of_materials bom
3581: WHERE bom.bill_sequence_id = p_rev_comp_unexp_rec.bill_sequence_id
3582: AND bom.source_bill_sequence_id <> bom.bill_sequence_id
3583: AND nvl(p_rev_component_rec.acd_type, 1) in (1,3);
3584: --Dont reject updates outright. Some updates are allowed on Common BOM.