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.ENGPKIMP dependencies on MTL_SYSTEM_ITEMS_B

Line 1161: || ' FROM mtl_system_items_b '

1157:
1158: EXCEPTION
1159: WHEN NO_DATA_FOUND THEN
1160: l_sql_stmt := ' SELECT lifecycle_id '
1161: || ' FROM mtl_system_items_b '
1162: || ' WHERE inventory_item_id = :1 '
1163: || ' AND organization_id = :2 ' ;
1164:
1165: BEGIN

Line 1616: -- replaced mtl_system_items by mtl_system_items_vl

1612: -- ERES change
1613: -- odab added columns change_id, organization_code
1614: -- , organization_name, concatenated_segments, description
1615: -- last_update_date, last_updated_by, creation_date, created_by
1616: -- replaced mtl_system_items by mtl_system_items_vl
1617: -- added joint tables mtl_parameters, hr_all_organization_units_tl
1618: Cursor get_item_info is
1619: Select i.change_notice,
1620: i.change_id, -- ERES change

Line 1809: mtl_system_items_b_kfv f

1805: c.component_item_revision_id,
1806: c.obj_name,
1807: c.component_remarks
1808: from bom_components_b c, --bom_inventory_components c,
1809: mtl_system_items_b_kfv f
1810: where c.revised_item_sequence_id = revised_item
1811: AND c.bill_sequence_id = cp_bill_sequence_id -- R12: Added for common bom changes
1812: and f.inventory_item_id = c.component_item_id
1813: and f.organization_id = item.organization_id

Line 2946: mtl_system_items_b_kfv f

2942: a.substitute_component_id,
2943: f.concatenated_segments item_number
2944: FROM bom_substitute_components a,
2945: bom_inventory_components b,
2946: mtl_system_items_b_kfv f
2947: WHERE a.component_sequence_id = b.component_sequence_id
2948: and b.revised_item_sequence_id = revised_item
2949: and f.inventory_item_id = a.substitute_component_id
2950: -- and f.organization_id = item.organization_id

Line 3020: select 1 from mtl_system_items_b where inventory_item_id in

3016: IF(item.transfer_or_copy_bill = 1 OR item.transfer_or_copy_routing = 1) then
3017: IF(item.implemented_only = 1) THEN
3018: --if it's implemented only then check if it's already implemented or going to be implemented as a part of this change...
3019: select count(*) into l_no_bom_dis_comps from dual where exists(
3020: select 1 from mtl_system_items_b where inventory_item_id in
3021: (
3022: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN
3023: (
3024: select bill_sequence_id from bom_bill_of_materials where

Line 3039: select 1 from mtl_system_items_b where inventory_item_id in

3035: );
3036: ELSE
3037: -- If implemented only is not set then check everything even other pending ECOS
3038: select count(*) into l_no_bom_dis_comps from dual where exists(
3039: select 1 from mtl_system_items_b where inventory_item_id in
3040: (
3041: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN
3042: (
3043: select bill_sequence_id from bom_bill_of_materials where

Line 3077: select 1 from mtl_system_items_b WHERE inventory_item_id IN

3073:
3074: --Get all the sub components for which bom_enabled_flag is false...
3075: IF(item.implemented_only = 1) THEN
3076: select count(*) into l_no_bom_dis_sub_comps from dual where exists(
3077: select 1 from mtl_system_items_b WHERE inventory_item_id IN
3078: (
3079: --Get all the sub components for all the components for this item
3080: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3081: -- Get all the components for this item

Line 3099: select 1 from mtl_system_items_b WHERE inventory_item_id IN

3095: ) and organization_id = item.organization_id and bom_enabled_flag = 'N'
3096: );
3097: ELSE
3098: select count(*) into l_no_bom_dis_sub_comps from dual where exists(
3099: select 1 from mtl_system_items_b WHERE inventory_item_id IN
3100: (
3101: --Get all the sub components for all the components for this item
3102: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3103: -- Get all the components for this item

Line 3222: select 1 from mtl_system_items_b where inventory_item_id in

3218: no_bom_disabled_sub_comps NUMBER;
3219: BEGIN
3220: --Check if there is atleast one component such that it's bom_enabled_flag is false for this Revised Item
3221: SELECT Count(*) INTO no_bom_disabled_comps FROM dual WHERE EXISTS(
3222: select 1 from mtl_system_items_b where inventory_item_id in
3223: (
3224: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN
3225: (
3226: select bill_sequence_id from bom_bill_of_materials where

Line 3253: select 1 from mtl_system_items_b WHERE inventory_item_id IN

3249: END IF;
3250:
3251: --Check if there is atleast one sub component such that it's bom_enabled_flag is false for this Revised Item
3252: SELECT Count(*) INTO no_bom_disabled_sub_comps FROM dual WHERE EXISTS(
3253: select 1 from mtl_system_items_b WHERE inventory_item_id IN
3254: (
3255: --Get all the sub components for all the components for this item
3256: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3257: -- Get all the components for this item