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_PARAMETERS

Line 107: SELECT organization_id INTO l_id FROM mtl_parameters

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);
107: SELECT organization_id INTO l_id FROM mtl_parameters
108: WHERE organization_code = l_pk1;
109: WHEN G_ITEM_CATALOG_GROUP THEN
110: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
111: SELECT item_catalog_group_id INTO l_id FROM mtl_item_catalog_groups_kfv

Line 185: FROM mtl_parameters

181: WHERE template_id = l_pk1;
182: WHEN G_ORGANIZATION THEN
183: l_pk1 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);
184: SELECT organization_code INTO l_code
185: FROM mtl_parameters
186: WHERE organization_id = l_pk1;
187: WHEN G_ITEM_CATALOG_GROUP THEN
188: l_pk1 := ID_COL_VALUE('item_catalog_group_id',p_pk_col_name_val_pairs);
189: SELECT concatenated_segments INTO l_code

Line 513: FROM mtl_parameters

509: l_default_master_org_id NUMBER;
510: l_master_org_code VARCHAR2(3);
511: CURSOR c_master_org IS
512: SELECT master_organization_id
513: FROM mtl_parameters
514: WHERE organization_id = master_organization_id;
515: BEGIN
516: OPEN c_master_org;
517: LOOP

Line 946: FROM mtl_parameters

942: l_org_id NUMBER;
943: BEGIN
944: SELECT organization_id
945: INTO l_org_id
946: FROM mtl_parameters
947: WHERE organization_code = p_organization_code;
948: RETURN l_org_id;
949: EXCEPTION
950: WHEN OTHERS THEN

Line 4433: FROM mtl_parameters WHERE organization_id=l_org_id;

4429: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
4430: ,p_entity_name=> G_INVENTORY_ITEM
4431: );
4432: SELECT MASTER_ORGANIZATION_ID INTO l_item_core_obj.MASTER_ORGANIZATION_ID
4433: FROM mtl_parameters WHERE organization_id=l_org_id;
4434: -- converts the master org id to master org code
4435: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
4436: l_pk_col_name_val_pairs.EXTEND(1);
4437: l_pk_col_name_val_pairs(1).name := 'organization_id';

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 4801: FROM mtl_parameters

4797: FOR i in l_org_tbl.FIRST..l_org_tbl.LAST LOOP
4798: BEGIN
4799: FND_MSG_PUB.initialize();
4800: SELECT COUNT(1) into l_entity_exist
4801: FROM mtl_parameters
4802: WHERE organization_code = l_org_tbl(i);
4803: IF l_entity_exist>0 THEN
4804: l_entity_count := l_entity_count +1;
4805: l_valid_org_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