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.INV_EBI_CHANGE_ORDER_HELPER dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1069: mtl_system_items_kfv it

1065: SELECT
1066: bic.component_sequence_id
1067: FROM
1068: bom_inventory_components bic,
1069: mtl_system_items_kfv it
1070: WHERE
1071: bic.bill_sequence_id = p_from_sequence_id
1072: AND bic.component_item_id = it.inventory_item_id
1073: AND it.organization_id = p_reference_org_id

Line 1083: mtl_system_items_kfv it

1079: sc.substitute_component_id,
1080: it.concatenated_segments substitute_component_name
1081: FROM
1082: bom_substitute_components sc,
1083: mtl_system_items_kfv it
1084: WHERE
1085: sc.substitute_component_id = it.inventory_item_id
1086: AND it.organization_id = p_reference_org_id
1087: AND sc.component_sequence_id = p_component_sequence_id

Line 1148: mtl_system_items_kfv it

1144: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.row_identifier ) row_identifier
1145: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.program_id) program_id
1146: FROM
1147: bom_substitute_components sc,
1148: mtl_system_items_kfv it
1149: WHERE
1150: sc.substitute_component_id = it.inventory_item_id AND
1151: it.organization_id = p_reference_org_id AND
1152: it.concatenated_segments = p_substitute_component_name AND

Line 1348: mtl_system_items_kfv it

1344: SELECT
1345: bic.component_sequence_id
1346: FROM
1347: bom_inventory_components bic,
1348: mtl_system_items_kfv it
1349: WHERE
1350: bic.bill_sequence_id = p_from_sequence_id
1351: AND bic.component_item_id = it.inventory_item_id
1352: AND it.organization_id = p_reference_org_id

Line 1623: mtl_system_items_kfv msi

1619: msi.concatenated_segments component_item_name,
1620: bic.component_item_id,
1621: bic.operation_seq_num
1622: FROM bom_inventory_components bic,
1623: mtl_system_items_kfv msi
1624: WHERE bic.bill_sequence_id = p_from_sequence_id
1625: AND bic.component_item_id = msi.inventory_item_id
1626: AND bic.component_item_id <> p_to_item_id
1627: AND NVL (bic.eco_for_production, 2) = 2

Line 1797: mtl_system_items_kfv it

1793: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.new_routing_revision) new_routing_revision
1794: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.return_status) return_status
1795: FROM
1796: bom_inventory_components bic,
1797: mtl_system_items_kfv it
1798: WHERE
1799: bic.component_item_id = it.inventory_item_id AND
1800: it.organization_id = p_reference_org_id AND
1801: it.concatenated_segments = p_component_item_name AND

Line 2101: mtl_system_items_kfv it,

2097: INTO
2098: l_Count
2099: FROM
2100: bom_bill_of_materials bb,
2101: mtl_system_items_kfv it,
2102: mtl_parameters mp
2103: WHERE
2104: bb.assembly_item_id = it.inventory_item_id AND
2105: it.organization_id = bb.organization_id AND

Line 2146: mtl_system_items_kfv it,

2142: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER: '|| p_Item_Number || ' ORG CODE: '|| p_Organization_Code);
2143:
2144: SELECT bill_sequence_id, source_bill_sequence_id INTO l_bill_sequence_id, l_src_bill_sequence_id
2145: FROM BOM_BILL_OF_MATERIALS bb,
2146: mtl_system_items_kfv it,
2147: mtl_parameters mp
2148: WHERE bb.assembly_item_id = it.inventory_item_id
2149: AND it.organization_id = bb.organization_id
2150: AND bb.organization_id = mp.organization_id

Line 2194: mtl_system_items_kfv msi,

2190: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER: '|| p_Item_Number || ' REVISION: '|| p_revision || ' ORG CODE: '|| p_org_code);
2191: SELECT COUNT(1) INTO l_Count
2192: FROM
2193: eng_revised_items eri,
2194: mtl_system_items_kfv msi,
2195: mtl_parameters mp
2196: WHERE
2197: eri.revised_item_id = msi.inventory_item_id AND
2198: msi.organization_id = eri.organization_id AND

Line 2322: l_reference_item_num mtl_system_items_kfv.concatenated_segments%TYPE;

2318: l_config_view_scope VARCHAR2(30) := 'ALL';
2319: l_config_impl_scope VARCHAR2(30) := 'ALL';
2320: l_return_status VARCHAR2(10);
2321: l_msg_Count NUMBER;
2322: l_reference_item_num mtl_system_items_kfv.concatenated_segments%TYPE;
2323: l_reference_org_code mtl_parameters.organization_code%TYPE;
2324: l_as_of_date DATE;
2325: l_alternate_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE;
2326: l_output_status inv_ebi_output_status;

Line 2381: mtl_system_items_kfv

2377: concatenated_segments
2378: INTO
2379: l_reference_item_num
2380: FROM
2381: mtl_system_items_kfv
2382: WHERE
2383: inventory_item_id = l_from_item_id AND
2384: organization_id = l_from_org_id;
2385: END IF;

Line 3348: FROM mtl_system_items_kfv

3344: IF(get_assign_item = FND_API.g_true ) THEN
3345: IF(INV_EBI_UTIL.is_pim_installed) THEN
3346: SELECT item_catalog_group_id, approval_status
3347: INTO l_item_catalog_group_id, l_approval_status
3348: FROM mtl_system_items_kfv
3349: WHERE organization_id = l_master_org
3350: AND concatenated_segments = p_item_name;
3351: IF (INV_EBI_ITEM_HELPER.is_new_item_request_reqd( l_item_catalog_group_id ) = FND_API.g_true) AND l_approval_status <> 'A'
3352: THEN

Line 3403: mtl_system_items_kfv msi

3399: --To check if master orgs current reviison is already there in context org
3400: SELECT COUNT(1) INTO l_count
3401: FROM
3402: mtl_item_revisions_b mir,
3403: mtl_system_items_kfv msi
3404: WHERE
3405: mir.organization_id = msi.organization_id AND
3406: msi.organization_id = p_organization_id AND
3407: mir.inventory_item_id = msi.inventory_item_id AND

Line 3598: mtl_system_items_kfv msi

3594: msi.concatenated_segments component_item_name ,
3595: bic.component_item_id
3596: FROM
3597: bom_inventory_components bic,
3598: mtl_system_items_kfv msi
3599: WHERE
3600: bic.bill_sequence_id = p_src_bill_sequence_id AND
3601: bic.component_item_id = msi.inventory_item_id AND
3602: msi.organization_id = p_src_organization_id AND

Line 3606: FROM mtl_system_items_kfv s

3602: msi.organization_id = p_src_organization_id AND
3603: NVL(bic.disable_date, sysdate + 1) >= sysdate AND
3604: NOT EXISTS
3605: ( SELECT 'x'
3606: FROM mtl_system_items_kfv s
3607: WHERE s.organization_id = p_organization_id
3608: AND s.inventory_item_id = bic.component_item_id
3609: AND ((p_assy_type = 1 AND s.eng_item_flag = 'N')
3610: OR (p_assy_type = 2)

Line 3668: mtl_system_items_kfv msi

3664: msi.concatenated_segments sub_comp_item_name ,
3665: bsc.substitute_component_id
3666: FROM bom_inventory_components bic,
3667: bom_substitute_components bsc,
3668: mtl_system_items_kfv msi
3669: WHERE bic.bill_sequence_id = p_src_bill_sequence_id
3670: AND bic.component_sequence_id = bsc.component_sequence_id
3671: AND bsc.substitute_component_id = msi.inventory_item_id
3672: AND msi.organization_id = p_src_organization_id

Line 4177: l_subst_comp_name mtl_system_items_kfv.concatenated_segments%TYPE;

4173: l_organization_id NUMBER;
4174: l_component_item_name VARCHAR2(240);
4175: l_master_org NUMBER;
4176: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
4177: l_subst_comp_name mtl_system_items_kfv.concatenated_segments%TYPE;
4178: l_return_status VARCHAR2(10);
4179: l_msg_count NUMBER;
4180: l_output_status inv_ebi_output_status;
4181: l_status_type NUMBER;