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_CROSS_REFERENCES_B

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 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