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_ITEM_HELPER dependencies on MTL_SYSTEM_ITEMS_KFV

Line 121: SELECT inventory_item_id INTO l_id FROM mtl_system_items_kfv

117: WHERE template_name =l_pk1;
118: WHEN G_INVENTORY_ITEM THEN
119: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
120: l_pk2 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);
121: SELECT inventory_item_id INTO l_id FROM mtl_system_items_kfv
122: WHERE concatenated_segments = l_pk1
123: AND organization_id = l_pk2;
124: WHEN G_ORGANIZATION THEN
125: l_pk1 := ID_COL_VALUE('organization_code',p_pk_col_name_val_pairs);

Line 1240: FROM mtl_system_items_kfv

1236: ) RETURN NUMBER IS
1237: l_inventory_item_id NUMBER;
1238: BEGIN
1239: SELECT inventory_item_id INTO l_inventory_item_id
1240: FROM mtl_system_items_kfv
1241: WHERE concatenated_segments = p_item_number
1242: AND organization_id = p_organization_id;
1243: RETURN l_inventory_item_id;
1244: EXCEPTION

Line 1319: FROM mtl_system_items_kfv

1315: ) RETURN VARCHAR IS
1316: l_item_flag VARCHAR2(1);
1317: BEGIN
1318: SELECT eng_item_flag INTO l_item_flag
1319: FROM mtl_system_items_kfv
1320: WHERE concatenated_segments = NVL(p_item_number,FND_API.G_MISS_CHAR)
1321: AND organization_id =p_organization_id;
1322: IF(l_item_flag='Y') THEN
1323: RETURN FND_API.g_true;

Line 1347: FROM mtl_system_items_kfv

1343: ) RETURN VARCHAR IS
1344: l_item_count NUMBER;
1345: BEGIN
1346: SELECT COUNT(1) INTO l_item_count
1347: FROM mtl_system_items_kfv
1348: WHERE concatenated_segments = p_item_number
1349: AND organization_id = p_organization_id;
1350: IF(l_item_count=0) THEN
1351: RETURN FND_API.g_false;

Line 1380: mtl_system_items_kfv msi

1376:
1377: SELECT COUNT(1) INTO l_count
1378: FROM
1379: mtl_item_revisions_b mir ,
1380: mtl_system_items_kfv msi
1381: WHERE
1382: msi.concatenated_segments = p_item_number AND
1383: msi.organization_id = p_organization_id AND
1384: msi.inventory_item_id = mir.inventory_item_id AND

Line 1568: FROM mtl_system_items_kfv

1564: p_item_number IN VARCHAR2
1565: ,p_organization_id IN NUMBER
1566: ) IS
1567: SELECT description
1568: FROM mtl_system_items_kfv
1569: WHERE concatenated_segments = p_item_number
1570: AND organization_id = p_organization_id;
1571:
1572: -- Added for bug 10416391

Line 2524: FROM mtl_system_items_kfv

2520: ,p_entity_name => G_ORGANIZATION
2521: );
2522: SELECT concatenated_segments,description
2523: INTO x_out.item_number,x_out.description
2524: FROM mtl_system_items_kfv
2525: WHERE organization_id = x_out.organization_id
2526: AND inventory_item_id = x_out.inventory_item_id;
2527: INV_EBI_UTIL.debug_line('STEP 140: BEFORE CALLING INV_EBI_ITEM_HELPER.get_Operating_unit ORG ID: '|| x_out.organization_id);
2528: get_Operating_unit

Line 6284: FROM mtl_system_items_kfv msik,mtl_parameters mp

6280: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
6281: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
6282: CURSOR c_get_all_orgs(p_item_name VARCHAR2) IS
6283: SELECT msik.inventory_item_id,msik.organization_id,mp.organization_code
6284: FROM mtl_system_items_kfv msik,mtl_parameters mp
6285: WHERE msik.concatenated_segments = p_item_name
6286: AND msik.organization_id = mp.organization_id;
6287: BEGIN
6288: x_return_status := FND_API.g_ret_sts_success;

Line 6307: FROM mtl_system_items_kfv

6303: FOR i in l_item_tbl.FIRST..l_item_tbl.LAST LOOP
6304: BEGIN
6305: FND_MSG_PUB.initialize();
6306: SELECT COUNT(1) into l_entity_exist
6307: FROM mtl_system_items_kfv
6308: WHERE concatenated_segments = l_item_tbl(i);
6309: IF l_entity_exist>0 THEN
6310: l_entity_count := l_entity_count +1;
6311: l_valid_item_tbl.EXTEND();

Line 6509: FROM mtl_cross_references_b mcr, mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz

6505: CURSOR c_get_item_list_pim IS
6506: SELECT inv_ebi_get_operational_attrs(item_pim.inventory_item_id,item_pim.concatenated_segments,item_pim.organization_id,item_pim.organization_code,NULL,NULL)
6507: FROM
6508: (SELECT mcr.inventory_item_id, msik.concatenated_segments, msi.organization_id, mp.organization_code
6509: FROM mtl_cross_references_b mcr, mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz
6510: WHERE mcr.inventory_item_id = msi.inventory_item_id
6511: --AND mcr.organization_id = msi.organization_id --8897962 mcr has organization_id value as null
6512: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))
6513: AND hz.orig_system_id = mcr.source_system_id

Line 6522: FROM mtl_cross_references_b mcr, cst_item_costs cic,mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz

6518: AND msi.last_update_date >= l_from_date
6519: AND msi.last_update_date <= l_to_date
6520: UNION
6521: SELECT cic.inventory_item_id, msik.concatenated_segments, cic.organization_id, mp.organization_code
6522: FROM mtl_cross_references_b mcr, cst_item_costs cic,mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz
6523: WHERE mcr.inventory_item_id = cic.inventory_item_id
6524: --AND mcr.organization_id = cic.organization_id
6525: AND msik.organization_id = mp.organization_id
6526: AND msik.organization_id = cic.organization_id

Line 6535: FROM mtl_cross_references_b mcr, cst_quantity_layers cql, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz

6531: AND cic.last_update_date >= l_from_date
6532: AND cic.last_update_date <= l_to_date
6533: UNION
6534: SELECT cql.inventory_item_id, msik.concatenated_segments, cql.organization_id, mp.organization_code
6535: FROM mtl_cross_references_b mcr, cst_quantity_layers cql, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz
6536: WHERE mcr.inventory_item_id = cql.inventory_item_id
6537: --AND mcr.organization_id = cql.organization_id
6538: AND msik.organization_id = mp.organization_id
6539: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))

Line 6550: FROM mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik

6546: CURSOR c_get_item_list IS
6547: SELECT inv_ebi_get_operational_attrs(item_npim.inventory_item_id,item_npim.concatenated_segments,item_npim.organization_id,item_npim.organization_code,NULL,NULL)
6548: FROM
6549: (SELECT msi.inventory_item_id, msik.concatenated_segments, msi.organization_id, mp.organization_code
6550: FROM mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik
6551: WHERE msi.organization_id = mp.organization_id
6552: AND msik.organization_id = msi.organization_id
6553: AND msik.inventory_item_id = msi.inventory_item_id
6554: AND msi.last_update_date <> msi.creation_date

Line 6559: FROM cst_item_costs cic, mtl_parameters mp, mtl_system_items_kfv msik

6555: AND msi.last_update_date >= l_from_date
6556: AND msi.last_update_date <= l_to_date
6557: UNION
6558: SELECT cic.inventory_item_id, msik.concatenated_segments, cic.organization_id, mp.organization_code
6559: FROM cst_item_costs cic, mtl_parameters mp, mtl_system_items_kfv msik
6560: WHERE cic.organization_id = mp.organization_id
6561: AND msik.organization_id = cic.organization_id
6562: AND msik.inventory_item_id = cic.inventory_item_id
6563: AND cic.last_update_date <> cic.creation_date

Line 6568: FROM cst_quantity_layers cql,mtl_parameters mp, mtl_system_items_kfv msik

6564: AND cic.last_update_date >= l_from_date
6565: AND cic.last_update_date <= l_to_date
6566: UNION
6567: SELECT cql.inventory_item_id, msik.concatenated_segments, cql.organization_id, mp.organization_code
6568: FROM cst_quantity_layers cql,mtl_parameters mp, mtl_system_items_kfv msik
6569: WHERE cql.organization_id=mp.organization_id
6570: AND msik.organization_id = cql.organization_id
6571: AND msik.inventory_item_id = cql.inventory_item_id
6572: AND cql.last_update_date >= l_from_date

Line 6797: FROM mtl_onhand_quantities_detail moq,mtl_cross_references_b mcr, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz

6793: CURSOR c_get_bal_item_lst_pim IS --8897962
6794: SELECT inv_ebi_get_operational_attrs(gibp.inventory_item_id,gibp.concatenated_segments, gibp.organization_id,gibp.organization_code,NULL,NULL)
6795: FROM (
6796: SELECT DISTINCT mcr.inventory_item_id,msik.concatenated_segments,moq.organization_id,mp.organization_code
6797: FROM mtl_onhand_quantities_detail moq,mtl_cross_references_b mcr, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz
6798: WHERE mcr.inventory_item_id = moq.inventory_item_id
6799: --AND mcr.organization_id = moq.organization_id
6800: AND moq.organization_id = mp.organization_id
6801: AND msik.organization_id = moq.organization_id

Line 6811: FROM mtl_onhand_quantities_detail moq, mtl_parameters mp, mtl_system_items_kfv msik

6807:
6808: CURSOR c_get_bal_item_lst IS
6809: SELECT inv_ebi_get_operational_attrs(gib.inventory_item_id,gib.concatenated_segments, gib.organization_id,gib.organization_code,NULL,NULL)
6810: FROM (SELECT DISTINCT moq.inventory_item_id,msik.concatenated_segments,moq.organization_id,mp.organization_code
6811: FROM mtl_onhand_quantities_detail moq, mtl_parameters mp, mtl_system_items_kfv msik
6812: WHERE moq.organization_id = mp.organization_id
6813: AND msik.organization_id = moq.organization_id
6814: AND msik.inventory_item_id = moq.inventory_item_id
6815: AND moq.last_update_date >= l_from_date