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

Line 98: mtl_system_items msi

94: WHERE EXISTS (
95: SELECT 1
96: FROM bom_bill_of_materials bbom,
97: bom_inventory_components bic,
98: mtl_system_items msi
99: WHERE bbom.assembly_item_id = L_NEW_ASSEMBLY_ITEM_ID
100: AND bbom.organization_id = VAR_ORGANIZATION_ID
101: AND ((VAR_SELECTION_OPTION = 2 AND
102: bBOM.ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 679: FROM mtl_system_items_kfv

675: WHERE revised_item_sequence_id = p_change_line_id;
676: -- Get the item details
677: SELECT item_catalog_group_id, lifecycle_id, current_phase_id , concatenated_segments
678: INTO l_item_catalog_cat_id, l_item_lifecycle_id, l_item_current_phase_id, l_concatenated_segments
679: FROM mtl_system_items_kfv
680: WHERE inventory_item_id = l_inventory_item_id
681: AND organization_id = l_org_id;
682:
683: -- Check whether there are any change policies for the current phase of item at any level which are not allowed

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 1756: mtl_system_items_vl si, -- ERES change

1752: i.enable_item_in_local_org,
1753: i.from_end_item_id,
1754: i.from_end_item_rev_id
1755: from eng_revised_items i,
1756: mtl_system_items_vl si, -- ERES change
1757: mtl_parameters mp1, -- ERES change
1758: hr_all_organization_units_tl hou -- ERES change
1759: where i.revised_item_sequence_id = revised_item
1760: and si.inventory_item_id = i.revised_item_id

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 2825: FROM mtl_system_items_kfv

2821:
2822: CURSOR mfgitem_already_exists(p_tomfg_item IN VARCHAR2)
2823: IS
2824: SELECT 1
2825: FROM mtl_system_items_kfv
2826: WHERE concatenated_segments = p_tomfg_item;
2827:
2828: CURSOR Get_starting_revision (p_org_id IN NUMBER)
2829: IS

Line 2837: From mtl_system_items msi

2833:
2834: Cursor Check_Item(p_item_id IN NUMBER,
2835: p_org_id IN NUMBER) is
2836: Select 'x' dummy
2837: From mtl_system_items msi
2838: Where msi.inventory_item_id = p_item_id
2839: And msi.organization_id = p_org_id
2840: And msi.eng_item_flag = 'N';
2841:

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

Line 3525: UPDATE mtl_system_items_tl SET description = l_new_description WHERE inventory_item_id = item.revised_item_id AND

3521: --commented out the below select statement for bug 9238945
3522: --SELECT new_item_description INTO l_new_description FROM eng_revised_items WHERE revised_item_sequence_id = item.revised_item_sequence_id;
3523:
3524: IF (l_new_description IS NOT NULL) THEN
3525: UPDATE mtl_system_items_tl SET description = l_new_description WHERE inventory_item_id = item.revised_item_id AND
3526: organization_id = item.organization_id AND source_lang = UserEnv('LANG');
3527: END IF;
3528: END;
3529: --Code changes for Enhancement 6084027 ends

Line 3622: SELECT mtl_system_items_s.NEXTVAL INTO l_new_assembly_item_id FROM dual;

3618: l_routing_revision := r1.starting_revision;
3619: END LOOP;
3620: END IF;
3621:
3622: SELECT mtl_system_items_s.NEXTVAL INTO l_new_assembly_item_id FROM dual;
3623:
3624: SELECT concatenated_copy_segments INTO l_concatenated_copy_segments
3625: FROM eng_revised_items WHERE revised_item_sequence_id = item.revised_item_sequence_id;
3626: