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_INVENTORY_COMPONENTS

Line 1431: FROM bom_inventory_components

1427: SELECT 1, 1
1428: INTO l_structure_exists_flag, l_create_bill_for_item
1429: FROM dual
1430: WHERE NOT EXISTS (SELECT 1
1431: FROM bom_inventory_components
1432: WHERE change_notice = sl.change_notice
1433: AND revised_item_sequence_id = sl.revised_item_sequence_id
1434: AND acd_type IN (2,3));
1435: EXCEPTION

Line 1694: from bom_inventory_components

1690: -- bug 10146196, check added to see if ECO has bill changes
1691: BEGIN
1692: select decode(count(*),0,'N','Y') --bug 14573265
1693: into l_eco_chg_exists
1694: from bom_inventory_components
1695: where change_notice = p_change_notice
1696: and pk2_value = p_local_org_id; --bug 14051321, add org_id to avoid error ORA-01422
1697:
1698: EXCEPTION

Line 1858: bom_inventory_components table hence this extra cursor. */

1854:
1855: /* cursor to pick up Revised component records for the top organization for
1856: the given change notice which have the ACD_type of Disable and have been
1857: implementedfrom eng_revised_items table. These records are not present in
1858: bom_inventory_components table hence this extra cursor. */
1859:
1860: CURSOR c_rev_comps_disable IS
1861: SELECT *
1862: FROM eng_revised_components

Line 1876: FROM bom_inventory_components

1872: given Change Notice*/
1873:
1874: CURSOR c_rev_comps IS
1875: SELECT *
1876: FROM bom_inventory_components
1877: WHERE change_notice = p_change_notice
1878: AND revised_item_sequence_id in
1879: (SELECT revised_item_sequence_id
1880: FROM eng_revised_items

Line 1893: FROM bom_inventory_components

1889: FROM bom_substitute_components
1890: WHERE change_notice = p_change_notice
1891: AND component_sequence_id in
1892: (SELECT component_sequence_id
1893: FROM bom_inventory_components
1894: WHERE change_notice = p_change_notice
1895: AND revised_item_sequence_id in
1896: (SELECT revised_item_sequence_id
1897: FROM eng_revised_items

Line 1910: FROM bom_inventory_components

1906: FROM bom_reference_designators
1907: WHERE change_notice = p_change_notice
1908: AND component_sequence_id in
1909: (SELECT component_sequence_id
1910: FROM bom_inventory_components
1911: WHERE change_notice = p_change_notice
1912: AND revised_item_sequence_id in
1913: (SELECT revised_item_sequence_id
1914: FROM eng_revised_items

Line 2520: from bom_inventory_components

2516:
2517: St_Number := 30;
2518: select operation_seq_num,trunc(effectivity_date)
2519: into old_operation_seq_num,l_old_effectivity_date
2520: from bom_inventory_components
2521: where COMPONENT_SEQUENCE_ID = rcd.OLD_COMPONENT_SEQUENCE_ID;
2522:
2523: St_Number := 40;
2524: select max(component_sequence_id)

Line 2526: from bom_inventory_components

2522:
2523: St_Number := 40;
2524: select max(component_sequence_id)
2525: into component_seq_id
2526: from bom_inventory_components
2527: where ((trunc(effectivity_date) = l_old_effectivity_date) OR
2528: (rcd.effectivity_date between
2529: trunc(effectivity_date) and
2530: NVL(disable_date, rcd.effectivity_date + 1)))

Line 2540: from bom_inventory_components

2536:
2537: St_Number := 50;
2538: select effectivity_date
2539: into old_effectivity_date
2540: from bom_inventory_components
2541: where component_sequence_id = component_seq_id;
2542:
2543: EXCEPTION
2544: WHEN NO_DATA_FOUND THEN

Line 2792: from bom_inventory_components

2788:
2789: St_Number := 30;
2790: select operation_seq_num,trunc(effectivity_date)
2791: into old_operation_seq_num,l_old_effectivity_date
2792: from bom_inventory_components
2793: where COMPONENT_SEQUENCE_ID = rc.OLD_COMPONENT_SEQUENCE_ID;
2794:
2795: St_Number := 40;
2796: select max(component_sequence_id)

Line 2798: from bom_inventory_components

2794:
2795: St_Number := 40;
2796: select max(component_sequence_id)
2797: into component_seq_id
2798: from bom_inventory_components
2799: where ((trunc(effectivity_date) = l_old_effectivity_date) OR
2800: (rc.effectivity_date between
2801: trunc(effectivity_date) and
2802: NVL(disable_date, rc.effectivity_date + 1))

Line 2814: from bom_inventory_components

2810:
2811: St_Number := 50;
2812: select effectivity_date
2813: into old_effectivity_date
2814: from bom_inventory_components
2815: where component_sequence_id = component_seq_id;
2816:
2817: EXCEPTION
2818: WHEN NO_DATA_FOUND THEN

Line 2957: bom_inventory_components bic

2953: SELECT msi.concatenated_segments,eri.new_item_revision
2954: INTO l_revised_item_name1,l_new_item_revision
2955: FROM mtl_system_items_b_kfv msi,
2956: eng_revised_items eri,
2957: bom_inventory_components bic
2958: WHERE bic.component_sequence_id = sc.component_sequence_id
2959: AND eri.revised_item_sequence_id = bic.revised_item_sequence_id
2960: AND eri.revised_item_id = msi.inventory_item_id
2961: AND msi.organization_id = l_org_id;

Line 2975: bom_inventory_components bic

2971: bic.operation_seq_num
2972: INTO l_component_item_name1,l_effectivity_date,
2973: l_operation_seq_num
2974: FROM mtl_system_items_b_kfv msi,
2975: bom_inventory_components bic
2976: WHERE bic.component_sequence_id = sc.component_sequence_id
2977: AND msi.inventory_item_id = bic.component_item_id
2978: AND msi.organization_id = l_org_id;
2979: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 3027: FROM bom_inventory_components bic,

3023: /* for bug 9368374 */
3024: BEGIN
3025: SELECT bom.alternate_bom_designator
3026: INTO l_alternate_bom
3027: FROM bom_inventory_components bic,
3028: bom_structures_b bom
3029: WHERE bic.component_sequence_id = sc.component_sequence_id
3030: AND bic.bill_sequence_id = bom.bill_sequence_id;
3031:

Line 3122: bom_inventory_components bic

3118: INTO l_revised_item_name2,l_new_item_revision,
3119: l_effectivity_date,l_operation_seq_num
3120: FROM mtl_system_items_b_kfv msi,
3121: eng_revised_items eri,
3122: bom_inventory_components bic
3123: WHERE bic.component_sequence_id = rd.component_sequence_id
3124: AND eri.revised_item_sequence_id = bic.revised_item_sequence_id
3125: AND eri.revised_item_id = msi.inventory_item_id
3126: AND msi.organization_id = l_org_id;

Line 3139: bom_inventory_components bic

3135: BEGIN
3136: SELECT concatenated_segments
3137: INTO l_component_item_name2
3138: FROM mtl_system_items_b_kfv msi,
3139: bom_inventory_components bic
3140: WHERE bic.component_sequence_id = rd.component_sequence_id
3141: AND msi.inventory_item_id = bic.component_item_id
3142: AND msi.organization_id = l_org_id;
3143: EXCEPTION

Line 3152: FROM bom_inventory_components bic,

3148: /* for bug 9368374 */
3149: BEGIN
3150: SELECT bom.alternate_bom_designator
3151: INTO l_alternate_bom
3152: FROM bom_inventory_components bic,
3153: bom_structures_b bom
3154: WHERE bic.component_sequence_id = rd.component_sequence_id
3155: AND bic.bill_sequence_id = bom.bill_sequence_id;
3156:

Line 3660: from bom_inventory_components

3656:
3657: St_Number := 30;
3658: select operation_seq_num,trunc(effectivity_date)
3659: into old_operation_seq_num,l_old_effectivity_date
3660: from bom_inventory_components
3661: where COMPONENT_SEQUENCE_ID = rc.OLD_COMPONENT_SEQUENCE_ID;
3662:
3663: St_Number := 40;
3664: select max(component_sequence_id)

Line 3666: from bom_inventory_components

3662:
3663: St_Number := 40;
3664: select max(component_sequence_id)
3665: into component_seq_id
3666: from bom_inventory_components
3667: where ((trunc(effectivity_date) = l_old_effectivity_date) OR
3668: (rc.effectivity_date between
3669: trunc(effectivity_date) and
3670: NVL(disable_date, rc.effectivity_date + 1))

Line 3681: from bom_inventory_components

3677:
3678: St_Number := 50;
3679: select effectivity_date
3680: into old_effectivity_date
3681: from bom_inventory_components
3682: where component_sequence_id = component_seq_id;
3683:
3684: EXCEPTION
3685: WHEN NO_DATA_FOUND THEN

Line 4955: -- bom_inventory_components table hence this extra cursor.

4951:
4952: -- Cursor to pick up Revised component records for the top organization for
4953: -- the given change notice which have the ACD_type of Disable and have been
4954: -- implemented from eng_revised_items table. These records are not present in
4955: -- bom_inventory_components table hence this extra cursor.
4956:
4957: CURSOR c_plm_rev_comps_disable (cp_revised_item_sequence_id NUMBER)
4958: IS
4959: SELECT *