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 1428: FROM bom_inventory_components

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

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

1835:
1836: /* cursor to pick up Revised component records for the top organization for
1837: the given change notice which have the ACD_type of Disable and have been
1838: implementedfrom eng_revised_items table. These records are not present in
1839: bom_inventory_components table hence this extra cursor. */
1840:
1841: CURSOR c_rev_comps_disable IS
1842: SELECT *
1843: FROM eng_revised_components

Line 1857: FROM bom_inventory_components

1853: given Change Notice*/
1854:
1855: CURSOR c_rev_comps IS
1856: SELECT *
1857: FROM bom_inventory_components
1858: WHERE change_notice = p_change_notice
1859: AND revised_item_sequence_id in
1860: (SELECT revised_item_sequence_id
1861: FROM eng_revised_items

Line 1874: FROM bom_inventory_components

1870: FROM bom_substitute_components
1871: WHERE change_notice = p_change_notice
1872: AND component_sequence_id in
1873: (SELECT component_sequence_id
1874: FROM bom_inventory_components
1875: WHERE change_notice = p_change_notice
1876: AND revised_item_sequence_id in
1877: (SELECT revised_item_sequence_id
1878: FROM eng_revised_items

Line 1891: FROM bom_inventory_components

1887: FROM bom_reference_designators
1888: WHERE change_notice = p_change_notice
1889: AND component_sequence_id in
1890: (SELECT component_sequence_id
1891: FROM bom_inventory_components
1892: WHERE change_notice = p_change_notice
1893: AND revised_item_sequence_id in
1894: (SELECT revised_item_sequence_id
1895: FROM eng_revised_items

Line 2463: from bom_inventory_components

2459:
2460: St_Number := 30;
2461: select operation_seq_num,trunc(effectivity_date)
2462: into old_operation_seq_num,l_old_effectivity_date
2463: from bom_inventory_components
2464: where COMPONENT_SEQUENCE_ID = rcd.OLD_COMPONENT_SEQUENCE_ID;
2465:
2466: St_Number := 40;
2467: select max(component_sequence_id)

Line 2469: from bom_inventory_components

2465:
2466: St_Number := 40;
2467: select max(component_sequence_id)
2468: into component_seq_id
2469: from bom_inventory_components
2470: where ((trunc(effectivity_date) = l_old_effectivity_date) OR
2471: (rcd.effectivity_date between
2472: trunc(effectivity_date) and
2473: NVL(disable_date, rcd.effectivity_date + 1)))

Line 2483: from bom_inventory_components

2479:
2480: St_Number := 50;
2481: select effectivity_date
2482: into old_effectivity_date
2483: from bom_inventory_components
2484: where component_sequence_id = component_seq_id;
2485:
2486: EXCEPTION
2487: WHEN NO_DATA_FOUND THEN

Line 2724: from bom_inventory_components

2720:
2721: St_Number := 30;
2722: select operation_seq_num,trunc(effectivity_date)
2723: into old_operation_seq_num,l_old_effectivity_date
2724: from bom_inventory_components
2725: where COMPONENT_SEQUENCE_ID = rc.OLD_COMPONENT_SEQUENCE_ID;
2726:
2727: St_Number := 40;
2728: select max(component_sequence_id)

Line 2730: from bom_inventory_components

2726:
2727: St_Number := 40;
2728: select max(component_sequence_id)
2729: into component_seq_id
2730: from bom_inventory_components
2731: where ((trunc(effectivity_date) = l_old_effectivity_date) OR
2732: (rc.effectivity_date between
2733: trunc(effectivity_date) and
2734: NVL(disable_date, rc.effectivity_date + 1))

Line 2746: from bom_inventory_components

2742:
2743: St_Number := 50;
2744: select effectivity_date
2745: into old_effectivity_date
2746: from bom_inventory_components
2747: where component_sequence_id = component_seq_id;
2748:
2749: EXCEPTION
2750: WHEN NO_DATA_FOUND THEN

Line 2889: bom_inventory_components bic

2885: SELECT msi.concatenated_segments,eri.new_item_revision
2886: INTO l_revised_item_name1,l_new_item_revision
2887: FROM mtl_system_items_b_kfv msi,
2888: eng_revised_items eri,
2889: bom_inventory_components bic
2890: WHERE bic.component_sequence_id = sc.component_sequence_id
2891: AND eri.revised_item_sequence_id = bic.revised_item_sequence_id
2892: AND eri.revised_item_id = msi.inventory_item_id
2893: AND msi.organization_id = l_org_id;

Line 2907: bom_inventory_components bic

2903: bic.operation_seq_num
2904: INTO l_component_item_name1,l_effectivity_date,
2905: l_operation_seq_num
2906: FROM mtl_system_items_b_kfv msi,
2907: bom_inventory_components bic
2908: WHERE bic.component_sequence_id = sc.component_sequence_id
2909: AND msi.inventory_item_id = bic.component_item_id
2910: AND msi.organization_id = l_org_id;
2911: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 3042: bom_inventory_components bic

3038: INTO l_revised_item_name2,l_new_item_revision,
3039: l_effectivity_date,l_operation_seq_num
3040: FROM mtl_system_items_b_kfv msi,
3041: eng_revised_items eri,
3042: bom_inventory_components bic
3043: WHERE bic.component_sequence_id = rd.component_sequence_id
3044: AND eri.revised_item_sequence_id = bic.revised_item_sequence_id
3045: AND eri.revised_item_id = msi.inventory_item_id
3046: AND msi.organization_id = l_org_id;

Line 3059: bom_inventory_components bic

3055: BEGIN
3056: SELECT concatenated_segments
3057: INTO l_component_item_name2
3058: FROM mtl_system_items_b_kfv msi,
3059: bom_inventory_components bic
3060: WHERE bic.component_sequence_id = rd.component_sequence_id
3061: AND msi.inventory_item_id = bic.component_item_id
3062: AND msi.organization_id = l_org_id;
3063: EXCEPTION

Line 3535: from bom_inventory_components

3531:
3532: St_Number := 30;
3533: select operation_seq_num,trunc(effectivity_date)
3534: into old_operation_seq_num,l_old_effectivity_date
3535: from bom_inventory_components
3536: where COMPONENT_SEQUENCE_ID = rc.OLD_COMPONENT_SEQUENCE_ID;
3537:
3538: St_Number := 40;
3539: select max(component_sequence_id)

Line 3541: from bom_inventory_components

3537:
3538: St_Number := 40;
3539: select max(component_sequence_id)
3540: into component_seq_id
3541: from bom_inventory_components
3542: where ((trunc(effectivity_date) = l_old_effectivity_date) OR
3543: (rc.effectivity_date between
3544: trunc(effectivity_date) and
3545: NVL(disable_date, rc.effectivity_date + 1))

Line 3556: from bom_inventory_components

3552:
3553: St_Number := 50;
3554: select effectivity_date
3555: into old_effectivity_date
3556: from bom_inventory_components
3557: where component_sequence_id = component_seq_id;
3558:
3559: EXCEPTION
3560: WHEN NO_DATA_FOUND THEN

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

4824:
4825: -- Cursor to pick up Revised component records for the top organization for
4826: -- the given change notice which have the ACD_type of Disable and have been
4827: -- implemented from eng_revised_items table. These records are not present in
4828: -- bom_inventory_components table hence this extra cursor.
4829:
4830: CURSOR c_plm_rev_comps_disable (cp_revised_item_sequence_id NUMBER)
4831: IS
4832: SELECT *