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 102: SELECT inventory_item_id INTO l_id FROM mtl_system_items_kfv

98: WHERE template_name =l_pk1;
99: WHEN G_INVENTORY_ITEM THEN
100: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
101: l_pk2 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);
102: SELECT inventory_item_id INTO l_id FROM mtl_system_items_kfv
103: WHERE concatenated_segments = l_pk1
104: AND organization_id = l_pk2;
105: WHEN G_ORGANIZATION THEN
106: l_pk1 := ID_COL_VALUE('organization_code',p_pk_col_name_val_pairs);

Line 965: FROM mtl_system_items_kfv

961: ) RETURN NUMBER IS
962: l_inventory_item_id NUMBER;
963: BEGIN
964: SELECT inventory_item_id INTO l_inventory_item_id
965: FROM mtl_system_items_kfv
966: WHERE concatenated_segments = p_item_number
967: AND organization_id = p_organization_id;
968: RETURN l_inventory_item_id;
969: EXCEPTION

Line 1044: FROM mtl_system_items_kfv

1040: ) RETURN VARCHAR IS
1041: l_item_flag VARCHAR2(1);
1042: BEGIN
1043: SELECT eng_item_flag INTO l_item_flag
1044: FROM mtl_system_items_kfv
1045: WHERE concatenated_segments = NVL(p_item_number,FND_API.G_MISS_CHAR)
1046: AND organization_id =p_organization_id;
1047: IF(l_item_flag='Y') THEN
1048: RETURN FND_API.g_true;

Line 1072: FROM mtl_system_items_kfv

1068: ) RETURN VARCHAR IS
1069: l_item_count NUMBER;
1070: BEGIN
1071: SELECT COUNT(1) INTO l_item_count
1072: FROM mtl_system_items_kfv
1073: WHERE concatenated_segments = p_item_number
1074: AND organization_id = p_organization_id;
1075: IF(l_item_count=0) THEN
1076: RETURN FND_API.g_false;

Line 1105: mtl_system_items_kfv msi

1101:
1102: SELECT COUNT(1) INTO l_count
1103: FROM
1104: mtl_item_revisions_b mir ,
1105: mtl_system_items_kfv msi
1106: WHERE
1107: msi.concatenated_segments = p_item_number AND
1108: msi.organization_id = p_organization_id AND
1109: msi.inventory_item_id = mir.inventory_item_id AND

Line 1195: FROM mtl_system_items_kfv

1191: p_item_number IN VARCHAR2
1192: ,p_organization_id IN NUMBER
1193: ) IS
1194: SELECT description
1195: FROM mtl_system_items_kfv
1196: WHERE concatenated_segments = p_item_number
1197: AND organization_id = p_organization_id;
1198: BEGIN
1199: SAVEPOINT inv_ebi_pvt_item_save_pnt;

Line 1849: FROM mtl_system_items_kfv

1845: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
1846: ,p_entity_name => G_ORGANIZATION
1847: );
1848: SELECT concatenated_segments INTO x_out.item_number
1849: FROM mtl_system_items_kfv
1850: WHERE organization_id = x_out.organization_id
1851: AND inventory_item_id = x_out.inventory_item_id;
1852:
1853: get_Operating_unit

Line 4747: FROM mtl_system_items_kfv msik,mtl_parameters mp

4743: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
4744: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
4745: CURSOR c_get_all_orgs(p_item_name VARCHAR2) IS
4746: SELECT msik.inventory_item_id,msik.organization_id,mp.organization_code
4747: FROM mtl_system_items_kfv msik,mtl_parameters mp
4748: WHERE msik.concatenated_segments = p_item_name
4749: AND msik.organization_id = mp.organization_id;
4750: BEGIN
4751: x_return_status := FND_API.g_ret_sts_success;

Line 4768: FROM mtl_system_items_kfv

4764: FOR i in l_item_tbl.FIRST..l_item_tbl.LAST LOOP
4765: BEGIN
4766: FND_MSG_PUB.initialize();
4767: SELECT COUNT(1) into l_entity_exist
4768: FROM mtl_system_items_kfv
4769: WHERE concatenated_segments = l_item_tbl(i);
4770: IF l_entity_exist>0 THEN
4771: l_entity_count := l_entity_count +1;
4772: l_valid_item_tbl.EXTEND();

Line 4932: FROM mtl_cross_references_b mcr, mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik

4928: CURSOR c_get_item_list_pim IS
4929: 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)
4930: FROM
4931: (SELECT mcr.inventory_item_id, msik.concatenated_segments, mcr.organization_id, mp.organization_code
4932: FROM mtl_cross_references_b mcr, mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik
4933: WHERE mcr.inventory_item_id = msi.inventory_item_id
4934: AND mcr.organization_id = msi.organization_id
4935: AND mcr.cross_reference_type = p_cross_reference_type
4936: AND mcr.organization_id = mp.organization_id

Line 4944: FROM mtl_cross_references_b mcr, cst_item_costs cic,mtl_parameters mp, mtl_system_items_kfv msik

4940: AND msi.last_update_date >= l_from_date
4941: AND msi.last_update_date <= l_to_date
4942: UNION
4943: SELECT cic.inventory_item_id, msik.concatenated_segments, cic.organization_id, mp.organization_code
4944: FROM mtl_cross_references_b mcr, cst_item_costs cic,mtl_parameters mp, mtl_system_items_kfv msik
4945: WHERE mcr.inventory_item_id = cic.inventory_item_id
4946: AND mcr.organization_id = cic.organization_id
4947: AND mcr.organization_id = mp.organization_id
4948: AND msik.organization_id = cic.organization_id

Line 4956: FROM mtl_cross_references_b mcr, cst_quantity_layers cql, mtl_parameters mp, mtl_system_items_kfv msik

4952: AND cic.last_update_date >= l_from_date
4953: AND cic.last_update_date <= l_to_date
4954: UNION
4955: SELECT cql.inventory_item_id, msik.concatenated_segments, cql.organization_id, mp.organization_code
4956: FROM mtl_cross_references_b mcr, cst_quantity_layers cql, mtl_parameters mp, mtl_system_items_kfv msik
4957: WHERE mcr.inventory_item_id = cql.inventory_item_id
4958: AND mcr.organization_id = cql.organization_id
4959: AND mcr.organization_id = mp.organization_id
4960: AND mcr.cross_reference_type = p_cross_reference_type

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

4966: CURSOR c_get_item_list IS
4967: 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)
4968: FROM
4969: (SELECT msi.inventory_item_id, msik.concatenated_segments, msi.organization_id, mp.organization_code
4970: FROM mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik
4971: WHERE msi.organization_id = mp.organization_id
4972: AND msik.organization_id = msi.organization_id
4973: AND msik.inventory_item_id = msi.inventory_item_id
4974: AND msi.last_update_date <> msi.creation_date

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

4974: AND msi.last_update_date <> msi.creation_date
4975: AND msi.last_update_date >= l_from_date AND msi.last_update_date <= l_to_date
4976: UNION
4977: SELECT cic.inventory_item_id, msik.concatenated_segments, cic.organization_id, mp.organization_code
4978: FROM cst_item_costs cic, mtl_parameters mp, mtl_system_items_kfv msik
4979: WHERE cic.organization_id = mp.organization_id
4980: AND msik.organization_id = cic.organization_id
4981: AND msik.inventory_item_id = cic.inventory_item_id
4982: AND cic.last_update_date <> cic.creation_date

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

4983: AND cic.last_update_date >= l_from_date
4984: AND cic.last_update_date <= l_to_date
4985: UNION
4986: SELECT cql.inventory_item_id, msik.concatenated_segments, cql.organization_id, mp.organization_code
4987: FROM cst_quantity_layers cql,mtl_parameters mp, mtl_system_items_kfv msik
4988: WHERE cql.organization_id=mp.organization_id
4989: AND msik.organization_id = cql.organization_id
4990: AND msik.inventory_item_id = cql.inventory_item_id
4991: AND cql.last_update_date >= l_from_date

Line 5159: FROM mtl_onhand_quantities_detail moq,mtl_cross_references_b mcr, mtl_parameters mp, mtl_system_items_kfv msik

5155: CURSOR c_get_bal_item_lst_pim IS
5156: SELECT inv_ebi_get_operational_attrs(gibp.inventory_item_id,gibp.concatenated_segments, gibp.organization_id,gibp.organization_code,NULL,NULL)
5157: FROM (
5158: SELECT DISTINCT mcr.inventory_item_id,msik.concatenated_segments,mcr.organization_id,mp.organization_code
5159: FROM mtl_onhand_quantities_detail moq,mtl_cross_references_b mcr, mtl_parameters mp, mtl_system_items_kfv msik
5160: WHERE mcr.inventory_item_id = moq.inventory_item_id
5161: AND mcr.organization_id = moq.organization_id
5162: AND mcr.organization_id = mp.organization_id
5163: AND msik.organization_id = moq.organization_id

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

5168:
5169: CURSOR c_get_bal_item_lst IS
5170: SELECT inv_ebi_get_operational_attrs(gib.inventory_item_id,gib.concatenated_segments, gib.organization_id,gib.organization_code,NULL,NULL)
5171: FROM (SELECT DISTINCT moq.inventory_item_id,msik.concatenated_segments,moq.organization_id,mp.organization_code
5172: FROM mtl_onhand_quantities_detail moq, mtl_parameters mp, mtl_system_items_kfv msik
5173: WHERE moq.organization_id = mp.organization_id
5174: AND msik.organization_id = moq.organization_id
5175: AND msik.inventory_item_id = moq.inventory_item_id
5176: AND moq.last_update_date >= l_from_date