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 2446: from BOM_COMPONENTS_B

2442:
2443: Cursor get_bill_seq_id(p_comp_sequence_id Number)
2444: IS
2445: SELECT bill_sequence_id
2446: from BOM_COMPONENTS_B
2447: where component_sequence_id = p_comp_sequence_id;
2448:
2449: Cursor get_structure_type(p_bill_seq_id NUMBER)
2450: IS

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

2506: SELECT Bom_Inventory_Components_S.NEXTVAL INTO l_component_seqeunce_id FROM dual;
2507:
2508: --Get the parents effectivity control
2509: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B
2510: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);
2511:
2512: -- IF the effectivity is not of date or rev return
2513: IF l_effectivity_control = 1 THEN
2514: SELECT Effectivity_Date INTO l_start_effectivity_date FROM MTL_ITEM_REVISIONS_B WHERE REVISION_ID = p_rev_id;

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

2511:
2512: -- IF the effectivity is not of date or rev return
2513: IF l_effectivity_control = 1 THEN
2514: SELECT Effectivity_Date INTO l_start_effectivity_date FROM MTL_ITEM_REVISIONS_B WHERE REVISION_ID = p_rev_id;
2515: SELECT Disable_date INTO l_disable_date FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id;
2516: l_start_rev_id := null;
2517: l_end_rev_id := null;
2518: ELSIF l_effectivity_control = 4 THEN
2519: SELECT SYSDATE INTO l_start_effectivity_date FROM dual;

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

2518: ELSIF l_effectivity_control = 4 THEN
2519: SELECT SYSDATE INTO l_start_effectivity_date FROM dual;
2520: l_disable_date := null;
2521: l_start_rev_id := p_rev_id;
2522: SELECT To_End_Item_Rev_Id INTO l_end_rev_id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id;
2523: ELSE
2524: l_component_seqeunce_id := 0;
2525: RETURN l_component_seqeunce_id;
2526: END IF;

Line 2531: UPDATE bom_components_b

2527:
2528: --Before creating new component, disable the existing row
2529: IF l_effectivity_control = 1
2530: THEN
2531: UPDATE bom_components_b
2532: SET disable_date = p_disable_date
2533: WHERE component_sequence_id = p_comp_seq_id;
2534: ELSIF l_effectivity_control = 4
2535: THEN

Line 2536: UPDATE bom_components_b

2532: SET disable_date = p_disable_date
2533: WHERE component_sequence_id = p_comp_seq_id;
2534: ELSIF l_effectivity_control = 4
2535: THEN
2536: UPDATE bom_components_b
2537: SET to_end_item_rev_id = p_disable_rev_id
2538: WHERE component_sequence_id = p_comp_seq_id;
2539: END IF;
2540:

Line 2543: INSERT INTO BOM_COMPONENTS_B

2539: END IF;
2540:
2541:
2542: --Create new Component
2543: INSERT INTO BOM_COMPONENTS_B
2544: ( SUPPLY_SUBINVENTORY
2545: , OPERATION_LEAD_TIME_PERCENT
2546: , REVISED_ITEM_SEQUENCE_ID
2547: , COST_FACTOR

Line 2705: FROM BOM_COMPONENTS_B comp_rec

2701: , l_end_rev_id
2702: , comp_rec.component_item_revision_id
2703: , comp_rec.basis_type
2704: , comp_rec.common_component_sequence_id
2705: FROM BOM_COMPONENTS_B comp_rec
2706: WHERE comp_rec.component_sequence_id = p_comp_seq_id;
2707:
2708: SELECT Count(1) INTO l_temp_num FROM bom_components_b WHERE component_sequence_id = l_component_seqeunce_id;
2709:

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

2704: , comp_rec.common_component_sequence_id
2705: FROM BOM_COMPONENTS_B comp_rec
2706: WHERE comp_rec.component_sequence_id = p_comp_seq_id;
2707:
2708: SELECT Count(1) INTO l_temp_num FROM bom_components_b WHERE component_sequence_id = l_component_seqeunce_id;
2709:
2710: --Copy component user attributes to new component
2711: copy_Comp_User_Attrs(p_src_comp_seq_id => p_comp_seq_id,
2712: p_dest_comp_seq_id => l_component_seqeunce_id,

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

2946: l_rev_code VARCHAR2(30);
2947: BEGIN
2948: --Get the parents effectivity control
2949: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B
2950: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);
2951:
2952: -- IF the effectivity is not of date or rev return
2953: BEGIN
2954: IF l_effectivity_control = 1 THEN -- DATE

Line 2966: bom_components_b bcb1, bom_components_b bcb2

2962: END IF;
2963: SELECT
2964: bcb2.component_sequence_id INTO l_component_seqeunce_id
2965: FROM
2966: bom_components_b bcb1, bom_components_b bcb2
2967: WHERE
2968: bcb1.component_sequence_id = p_comp_seq_id
2969: AND bcb1.bill_sequence_id = bcb2.bill_sequence_id
2970: AND nvl(bcb1.obj_name,'EGO_ITEM') = nvl(bcb2.obj_name,'EGO_ITEM')

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

2978: SELECT Revision INTO l_rev_code FROM MTL_ITEM_REVISIONS_B WHERE REVISION_ID = p_rev_id;
2979: SELECT
2980: bcb2.component_sequence_id INTO l_component_seqeunce_id
2981: FROM
2982: bom_components_b bcb1, bom_components_b bcb2, mtl_item_revisions_b mirb1, mtl_item_revisions_b mirb2
2983: WHERE
2984: bcb1.component_sequence_id = p_comp_seq_id
2985: AND bcb1.bill_sequence_id = bcb2.bill_sequence_id
2986: AND nvl(bcb1.obj_name,'EGO_ITEM') = nvl(bcb2.obj_name,'EGO_ITEM')

Line 3320: FROM bom_components_b

3316:
3317: CURSOR get_item_details
3318: IS
3319: SELECT pk1_value, pk2_value
3320: FROM bom_components_b
3321: WHERE INSTR(','||p_comp_seq_ids||',', ','||component_sequence_id||',') > 0;
3322:
3323: BEGIN
3324: FOR item IN get_item_details