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_GLOBALS dependencies on BOM_COMPONENTS_B

Line 1609: , bom_components_b comp

1605: cursor c_ref_desg ( p_component_seq IN NUMBER)
1606: IS
1607: SELECT component_reference_designator
1608: FROM bom_reference_designators rd
1609: , bom_components_b comp
1610: WHERE comp.component_sequence_id = p_component_seq
1611: AND rd.component_sequence_id = comp.component_sequence_id
1612: AND ( (comp.implementation_date IS NULL AND
1613: rd.change_notice = comp.change_notice

Line 2353: FROM BOM_COMPONENTS_B

2349: BEGIN
2350:
2351: SELECT from_end_item_rev_id, to_end_item_rev_id, effectivity_date, disable_date
2352: INTO l_start_rev_id, l_end_rev_id, l_effective_date, l_disable_date
2353: FROM BOM_COMPONENTS_B
2354: WHERE component_sequence_id = p_component_sequence_id;
2355:
2356: IF p_context_rev_id IS NOT NULL
2357: THEN

Line 2367: FROM bom_components_b

2363: SELECT effectivity_control
2364: INTO l_eff_ctrl
2365: FROM BOM_STRUCTURES_B
2366: WHERE bill_sequence_id = (SELECT bill_sequence_id
2367: FROM bom_components_b
2368: WHERE component_sequence_id = p_component_sequence_id
2369: AND ROWNUM = 1);
2370:
2371: IF l_eff_ctrl = 1 AND SYSDATE BETWEEN l_effective_date AND l_start_date

Line 2412: FROM BOM_COMPONENTS_B

2408: BEGIN
2409:
2410: SELECT from_end_item_rev_id, to_end_item_rev_id, effectivity_date, disable_date
2411: INTO l_start_rev_id, l_end_rev_id, l_effective_date, l_disable_date
2412: FROM BOM_COMPONENTS_B
2413: WHERE component_sequence_id = p_component_sequence_id;
2414:
2415: RETURN Check_Change_Policy_Range (p_item_id => p_item_id,
2416: p_org_id => p_org_id,

Line 2451: from BOM_COMPONENTS_B

2447:
2448: Cursor get_bill_seq_id(p_comp_sequence_id Number)
2449: IS
2450: SELECT bill_sequence_id
2451: from BOM_COMPONENTS_B
2452: where component_sequence_id = p_comp_sequence_id;
2453:
2454: Cursor get_structure_type(p_bill_seq_id NUMBER)
2455: IS

Line 2548: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);

2544: SELECT Bom_Inventory_Components_S.NEXTVAL INTO l_component_seqeunce_id FROM dual;
2545:
2546: --Get the parents effectivity control
2547: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B
2548: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);
2549:
2550: -- IF the effectivity is not of date or rev return
2551: IF l_effectivity_control = 1 THEN
2552: SELECT Effectivity_Date INTO l_start_effectivity_date FROM MTL_ITEM_REVISIONS_B WHERE REVISION_ID = p_rev_id;

Line 2553: SELECT Disable_date INTO l_disable_date FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id;

2549:
2550: -- IF the effectivity is not of date or rev return
2551: IF l_effectivity_control = 1 THEN
2552: SELECT Effectivity_Date INTO l_start_effectivity_date FROM MTL_ITEM_REVISIONS_B WHERE REVISION_ID = p_rev_id;
2553: SELECT Disable_date INTO l_disable_date FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id;
2554: l_start_rev_id := null;
2555: l_end_rev_id := null;
2556: ELSIF l_effectivity_control = 4 THEN
2557: SELECT SYSDATE INTO l_start_effectivity_date FROM dual;

Line 2560: SELECT To_End_Item_Rev_Id INTO l_end_rev_id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id;

2556: ELSIF l_effectivity_control = 4 THEN
2557: SELECT SYSDATE INTO l_start_effectivity_date FROM dual;
2558: l_disable_date := null;
2559: l_start_rev_id := p_rev_id;
2560: SELECT To_End_Item_Rev_Id INTO l_end_rev_id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id;
2561: ELSE
2562: l_component_seqeunce_id := 0;
2563: RETURN l_component_seqeunce_id;
2564: END IF;

Line 2569: UPDATE bom_components_b

2565:
2566: --Before creating new component, disable the existing row
2567: IF l_effectivity_control = 1
2568: THEN
2569: UPDATE bom_components_b
2570: SET disable_date = p_disable_date
2571: WHERE component_sequence_id = p_comp_seq_id;
2572: ELSIF l_effectivity_control = 4
2573: THEN

Line 2574: UPDATE bom_components_b

2570: SET disable_date = p_disable_date
2571: WHERE component_sequence_id = p_comp_seq_id;
2572: ELSIF l_effectivity_control = 4
2573: THEN
2574: UPDATE bom_components_b
2575: SET to_end_item_rev_id = p_disable_rev_id
2576: WHERE component_sequence_id = p_comp_seq_id;
2577: END IF;
2578:

Line 2581: INSERT INTO BOM_COMPONENTS_B

2577: END IF;
2578:
2579:
2580: --Create new Component
2581: INSERT INTO BOM_COMPONENTS_B
2582: ( SUPPLY_SUBINVENTORY
2583: , OPERATION_LEAD_TIME_PERCENT
2584: , REVISED_ITEM_SEQUENCE_ID
2585: , COST_FACTOR

Line 2743: FROM BOM_COMPONENTS_B comp_rec

2739: , l_end_rev_id
2740: , comp_rec.component_item_revision_id
2741: , comp_rec.basis_type
2742: , comp_rec.common_component_sequence_id
2743: FROM BOM_COMPONENTS_B comp_rec
2744: WHERE comp_rec.component_sequence_id = p_comp_seq_id;
2745:
2746: SELECT Count(1) INTO l_temp_num FROM bom_components_b WHERE component_sequence_id = l_component_seqeunce_id;
2747:

Line 2746: SELECT Count(1) INTO l_temp_num FROM bom_components_b WHERE component_sequence_id = l_component_seqeunce_id;

2742: , comp_rec.common_component_sequence_id
2743: FROM BOM_COMPONENTS_B comp_rec
2744: WHERE comp_rec.component_sequence_id = p_comp_seq_id;
2745:
2746: SELECT Count(1) INTO l_temp_num FROM bom_components_b WHERE component_sequence_id = l_component_seqeunce_id;
2747:
2748: --Copy component user attributes to new component
2749: copy_Comp_User_Attrs(p_src_comp_seq_id => p_comp_seq_id,
2750: p_dest_comp_seq_id => l_component_seqeunce_id,

Line 2993: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);

2989: l_rev_code VARCHAR2(30);
2990: BEGIN
2991: --Get the parents effectivity control
2992: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B
2993: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);
2994:
2995: -- IF the effectivity is not of date or rev return
2996: BEGIN
2997: IF l_effectivity_control = 1 THEN -- DATE

Line 3009: bom_components_b bcb1, bom_components_b bcb2

3005: END IF;
3006: SELECT
3007: bcb2.component_sequence_id INTO l_component_seqeunce_id
3008: FROM
3009: bom_components_b bcb1, bom_components_b bcb2
3010: WHERE
3011: bcb1.component_sequence_id = p_comp_seq_id
3012: AND bcb1.bill_sequence_id = bcb2.bill_sequence_id
3013: AND nvl(bcb1.obj_name,'EGO_ITEM') = nvl(bcb2.obj_name,'EGO_ITEM')

Line 3025: bom_components_b bcb1, bom_components_b bcb2, mtl_item_revisions_b mirb1, mtl_item_revisions_b mirb2

3021: SELECT Revision INTO l_rev_code FROM MTL_ITEM_REVISIONS_B WHERE REVISION_ID = p_rev_id;
3022: SELECT
3023: bcb2.component_sequence_id INTO l_component_seqeunce_id
3024: FROM
3025: bom_components_b bcb1, bom_components_b bcb2, mtl_item_revisions_b mirb1, mtl_item_revisions_b mirb2
3026: WHERE
3027: bcb1.component_sequence_id = p_comp_seq_id
3028: AND bcb1.bill_sequence_id = bcb2.bill_sequence_id
3029: AND nvl(bcb1.obj_name,'EGO_ITEM') = nvl(bcb2.obj_name,'EGO_ITEM')

Line 3383: FROM bom_components_b

3379:
3380: CURSOR get_item_details
3381: IS
3382: SELECT pk1_value, pk2_value
3383: FROM bom_components_b
3384: WHERE INSTR(','||p_comp_seq_ids||',', ','||component_sequence_id||',') > 0;
3385:
3386: BEGIN
3387: FOR item IN get_item_details