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 1484: FROM bom_bill_of_materials

1480: BEGIN
1481: -- If Phantom then Component must be a Bill
1482: SELECT 'Valid'
1483: INTO l_dummy
1484: FROM bom_bill_of_materials
1485: WHERE assembly_item_id =
1486: g_rev_comp_unexp_rec.component_item_id
1487: AND organization_id =
1488: g_rev_comp_unexp_rec.organization_id

Line 1980: FROM bom_bill_of_materials

1976: l_alternate_bom_designator VARCHAR2(10) := NULL;
1977:
1978: CURSOR GetAlternate IS
1979: SELECT alternate_bom_designator
1980: FROM bom_bill_of_materials
1981: WHERE bill_sequence_id = g_rev_comp_unexp_rec.bill_sequence_id;
1982:
1983: CURSOR CheckRouting IS
1984: SELECT 'x'

Line 2401: FROM BOM_BILL_OF_MATERIALS bom

2397: l_invalid_bill NUMBER;
2398: l_allow_eng_comps varchar2(10) := nvl(fnd_profile.value('ENG:ALLOW_ENG_COMPS'), '2'); -- Bug 6274872
2399: CURSOR bom_enabled_in_other_orgs IS
2400: SELECT 1
2401: FROM BOM_BILL_OF_MATERIALS bom
2402: WHERE bom.source_bill_sequence_id =
2403: g_rev_comp_Unexp_rec.bill_sequence_id
2404: AND bom.organization_id <>
2405: g_rev_comp_Unexp_rec.organization_id

Line 2417: FROM BOM_BILL_OF_MATERIALS bom

2413: );
2414:
2415: CURSOR in_other_orgs IS
2416: SELECT 1
2417: FROM BOM_BILL_OF_MATERIALS bom
2418: WHERE bom.source_bill_sequence_id =
2419: g_rev_comp_Unexp_rec.bill_sequence_id
2420: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
2421: AND NOT EXISTS (SELECT 1

Line 2431: FROM BOM_BILL_OF_MATERIALS bom

2427:
2428: CURSOR eng_flag_in_other_orgs
2429: IS
2430: SELECT 1
2431: FROM BOM_BILL_OF_MATERIALS bom
2432: WHERE bom.source_bill_sequence_id =
2433: g_rev_comp_Unexp_rec.bill_sequence_id
2434: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
2435: AND NOT EXISTS (SELECT 1

Line 2452: FROM BOM_BILL_OF_MATERIALS

2448:
2449: /*Cursor editable_common_bom_other_org
2450: IS
2451: SELECT bill_Sequence_id
2452: FROM BOM_BILL_OF_MATERIALS
2453: WHERE common_bill_Sequence_id <> source_bill_sequence_id
2454: AND source_bill_sequence_id = g_rev_comp_Unexp_rec.bill_sequence_id
2455: AND organization_id <> g_rev_comp_Unexp_rec.organization_id;
2456:

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

2456:
2457: Cursor valid_op_seq(p_bill_seq_id NUMBER)
2458: IS
2459: SELECT 1
2460: FROM BOM_OPERATION_SEQUENCES bos, BOM_OPERATIONAL_ROUTINGS bor, BOM_BILL_OF_MATERIALS bom
2461: WHERE (bor.routing_sequence_id = bos.routing_sequence_id
2462: AND bor.assembly_item_id = bom.assembly_item_id
2463: AND bor.organization_id = bom.organization_id
2464: AND nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')

Line 2517: FROM bom_bill_of_materials

2513: RETURN BOOLEAN
2514: IS
2515: CURSOR c_CheckPrimary IS
2516: SELECT 1
2517: FROM bom_bill_of_materials
2518: WHERE assembly_item_id = g_Rev_Comp_Unexp_Rec.revised_item_id
2519: AND organization_id = g_Rev_Comp_Unexp_Rec.Organization_Id
2520: AND NVL(alternate_bom_designator, 'NONE') = 'NONE';
2521: BEGIN

Line 2558: FROM bom_bill_of_materials

2554: , p_organization_id NUMBER)
2555: IS
2556:
2557: SELECT 1
2558: FROM bom_bill_of_materials
2559: WHERE assembly_item_id = p_revied_item_id
2560: AND organization_id = p_organization_id
2561: AND NVL(alternate_bom_designator, 'NONE') = 'NONE';
2562:

Line 2914: FROM BOM_BILL_OF_MATERIALS

2910: IS
2911: l_deref_bom varchar2(1);
2912: BEGIN
2913: SELECT 'Y' into l_deref_bom
2914: FROM BOM_BILL_OF_MATERIALS
2915: WHERE bill_sequence_id = common_bill_sequence_id
2916: AND bill_sequence_id <> nvl(source_bill_sequence_id, common_bill_sequence_id)
2917: AND bill_sequence_id = p_bill_sequence_id;
2918: IF l_deref_bom = 'Y' THEN

Line 3105: FROM bom_bill_of_materials bom

3101: WHERE eri.revised_item_sequence_id =
3102: p_rev_comp_Unexp_rec.revised_item_sequence_id
3103: AND eri.bill_sequence_id IS NULL
3104: AND NOT EXISTS (SELECT 1
3105: FROM bom_bill_of_materials bom
3106: WHERE bom.bill_sequence_id =
3107: p_rev_comp_Unexp_rec.bill_sequence_id
3108: );
3109:

Line 3336: from bom_bill_of_materials

3332: select assembly_type
3333: into g_Assy_Assembly_Type
3334: --bug: 4161794. Introduced new global variable to hold value of assembly type
3335: -- of the header.
3336: from bom_bill_of_materials
3337: where bill_sequence_id = p_rev_comp_Unexp_rec.bill_sequence_id;
3338: END IF;
3339:
3340: --if an ATO item was added in a kit when the related profile was set, you cannot

Line 3694: FROM bom_bill_of_materials bom

3690: BEGIN
3691: IF Bom_Globals.Get_Caller_Type <> 'MIGRATION' THEN
3692: SELECT 'Valid'
3693: INTO l_dummy
3694: FROM bom_bill_of_materials bom
3695: WHERE bom.bill_sequence_id = p_rev_comp_unexp_rec.bill_sequence_id
3696: AND bom.source_bill_sequence_id <> bom.bill_sequence_id
3697: AND nvl(p_rev_component_rec.acd_type, 1) in (1,3);
3698: