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 1233: || ' FROM mtl_system_items_b '

1229:
1230: EXCEPTION
1231: WHEN NO_DATA_FOUND THEN
1232: l_sql_stmt := ' SELECT lifecycle_id '
1233: || ' FROM mtl_system_items_b '
1234: || ' WHERE inventory_item_id = :1 '
1235: || ' AND organization_id = :2 ' ;
1236:
1237: BEGIN

Line 1693: -- replaced mtl_system_items by mtl_system_items_vl

1689: -- ERES change
1690: -- odab added columns change_id, organization_code
1691: -- , organization_name, concatenated_segments, description
1692: -- last_update_date, last_updated_by, creation_date, created_by
1693: -- replaced mtl_system_items by mtl_system_items_vl
1694: -- added joint tables mtl_parameters, hr_all_organization_units_tl
1695: Cursor get_item_info is
1696: Select i.change_notice,
1697: i.change_id, -- ERES change

Line 1902: mtl_system_items_b_kfv f

1898: f.replenish_to_order_flag, --BOM ER 9946990
1899: c.optional, --BOM ER 9946990
1900: c.component_remarks
1901: from bom_components_b c, --bom_inventory_components c,
1902: mtl_system_items_b_kfv f
1903: where c.revised_item_sequence_id = revised_item
1904: AND c.bill_sequence_id = cp_bill_sequence_id -- R12: Added for common bom changes
1905: and f.inventory_item_id = c.component_item_id
1906: and f.organization_id = item.organization_id

Line 3077: mtl_system_items_b_kfv f

3073: a.substitute_component_id,
3074: f.concatenated_segments item_number
3075: FROM bom_substitute_components a,
3076: bom_inventory_components b,
3077: mtl_system_items_b_kfv f
3078: WHERE a.component_sequence_id = b.component_sequence_id
3079: and b.revised_item_sequence_id = revised_item
3080: and f.inventory_item_id = a.substitute_component_id
3081: -- and f.organization_id = item.organization_id

Line 3176: select 1 from mtl_system_items_b where inventory_item_id in

3172: IF(item.transfer_or_copy_bill = 1 OR item.transfer_or_copy_routing = 1) then
3173: IF(item.implemented_only = 1) THEN
3174: --if it's implemented only then check if it's already implemented or going to be implemented as a part of this change...
3175: select count(*) into l_no_bom_dis_comps from dual where exists(
3176: select 1 from mtl_system_items_b where inventory_item_id in
3177: (
3178: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN
3179: (
3180: select bill_sequence_id from bom_bill_of_materials where

Line 3212: select 1 from mtl_system_items_b where inventory_item_id in

3208: );
3209: ELSE
3210: -- If implemented only is not set then check everything even other pending ECOS
3211: select count(*) into l_no_bom_dis_comps from dual where exists(
3212: select 1 from mtl_system_items_b where inventory_item_id in
3213: (
3214: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN
3215: (
3216: select bill_sequence_id from bom_bill_of_materials where

Line 3267: select 1 from mtl_system_items_b WHERE inventory_item_id IN

3263:
3264: --Get all the sub components for which bom_enabled_flag is false...
3265: IF(item.implemented_only = 1) THEN
3266: select count(*) into l_no_bom_dis_sub_comps from dual where exists(
3267: select 1 from mtl_system_items_b WHERE inventory_item_id IN
3268: (
3269: --Get all the sub components for all the components for this item
3270: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3271: -- Get all the components for this item

Line 3306: select 1 from mtl_system_items_b WHERE inventory_item_id IN

3302: ) and organization_id = item.organization_id and bom_enabled_flag = 'N'
3303: );
3304: ELSE
3305: select count(*) into l_no_bom_dis_sub_comps from dual where exists(
3306: select 1 from mtl_system_items_b WHERE inventory_item_id IN
3307: (
3308: --Get all the sub components for all the components for this item
3309: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3310: -- Get all the components for this item

Line 3446: select 1 from mtl_system_items_b where inventory_item_id in

3442: no_bom_disabled_sub_comps NUMBER;
3443: BEGIN
3444: --Check if there is atleast one component such that it's bom_enabled_flag is false for this Revised Item
3445: SELECT Count(*) INTO no_bom_disabled_comps FROM dual WHERE EXISTS(
3446: select 1 from mtl_system_items_b where inventory_item_id in
3447: (
3448: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN
3449: (
3450: select bill_sequence_id from bom_bill_of_materials where

Line 3477: select 1 from mtl_system_items_b WHERE inventory_item_id IN

3473: END IF;
3474:
3475: --Check if there is atleast one sub component such that it's bom_enabled_flag is false for this Revised Item
3476: SELECT Count(*) INTO no_bom_disabled_sub_comps FROM dual WHERE EXISTS(
3477: select 1 from mtl_system_items_b WHERE inventory_item_id IN
3478: (
3479: --Get all the sub components for all the components for this item
3480: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3481: -- Get all the components for this item

Line 3514: l_new_description mtl_system_items_b.description%TYPE;

3510: --Code changes for bug 5846248 ends
3511:
3512: --Code changes for Enhancement 6084027 start, update description while implementing the Co
3513: DECLARE
3514: l_new_description mtl_system_items_b.description%TYPE;
3515: BEGIN
3516: -- Get the new description from the eng_revised_items table
3517: -- check if the value is not null
3518: -- update the production if this value is not null