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 126: SELECT organization_id INTO l_id FROM mtl_parameters

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);
126: SELECT organization_id INTO l_id FROM mtl_parameters
127: WHERE organization_code = l_pk1;
128: WHEN G_ITEM_CATALOG_GROUP THEN
129: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
130: SELECT item_catalog_group_id INTO l_id FROM mtl_item_catalog_groups_kfv

Line 207: FROM mtl_parameters

203: WHERE template_id = l_pk1;
204: WHEN G_ORGANIZATION THEN
205: l_pk1 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);
206: SELECT organization_code INTO l_code
207: FROM mtl_parameters
208: WHERE organization_id = l_pk1;
209: WHEN G_ITEM_CATALOG_GROUP THEN
210: l_pk1 := ID_COL_VALUE('item_catalog_group_id',p_pk_col_name_val_pairs);
211: SELECT concatenated_segments INTO l_code

Line 565: FROM mtl_parameters

561: l_default_master_org_id NUMBER;
562: l_master_org_code VARCHAR2(3);
563: CURSOR c_master_org IS
564: SELECT master_organization_id
565: FROM mtl_parameters
566: WHERE organization_id = master_organization_id;
567: BEGIN
568: OPEN c_master_org;
569: LOOP

Line 1221: FROM mtl_parameters

1217: l_org_id NUMBER;
1218: BEGIN
1219: SELECT organization_id
1220: INTO l_org_id
1221: FROM mtl_parameters
1222: WHERE organization_code = p_organization_code;
1223: RETURN l_org_id;
1224: EXCEPTION
1225: WHEN OTHERS THEN

Line 5965: FROM mtl_parameters WHERE organization_id=l_org_id;

5961: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
5962: ,p_entity_name=> G_INVENTORY_ITEM
5963: );
5964: SELECT MASTER_ORGANIZATION_ID INTO l_item_core_obj.MASTER_ORGANIZATION_ID
5965: FROM mtl_parameters WHERE organization_id=l_org_id;
5966: -- converts the master org id to master org code
5967: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
5968: l_pk_col_name_val_pairs.EXTEND(1);
5969: l_pk_col_name_val_pairs(1).name := 'organization_id';

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

6336: FOR i in l_org_tbl.FIRST..l_org_tbl.LAST LOOP
6337: BEGIN
6338: FND_MSG_PUB.initialize();
6339: SELECT COUNT(1) into l_entity_exist
6340: FROM mtl_parameters
6341: WHERE organization_code = l_org_tbl(i);
6342: IF l_entity_exist>0 THEN
6343: l_entity_count := l_entity_count +1;
6344: l_valid_org_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