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 2548: FROM MTL_CROSS_REFERENCES_B MCR

2544:
2545: BEGIN
2546: SELECT COUNT(*)
2547: INTO l_count
2548: FROM MTL_CROSS_REFERENCES_B MCR
2549: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
2550: AND nvl(MCR.SOURCE_SYSTEM_ID,-99999) = nvl(l_source_system_id,-99999) --Bug 8704166
2551: AND MCR.CROSS_REFERENCE = l_item.main_obj_type.item_number
2552: AND MCR.INVENTORY_ITEM_ID = x_out.inventory_item_id

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