APPS.INV_EBI_ITEM_HELPER dependencies on HZ_ORIG_SYSTEMS_B

Line 2537: FROM HZ_ORIG_SYSTEMS_B

2533: INV_EBI_UTIL.debug_line('STEP 150: AFTER CALLING INV_EBI_ITEM_HELPER.get_Operating_unit OPERATING UNIT: '|| x_out.operating_unit);
2534: BEGIN
2535: SELECT orig_system_id
2536: INTO l_source_system_id
2537: FROM HZ_ORIG_SYSTEMS_B
2538: WHERE orig_system = l_item.main_obj_type.cross_reference_type;
2539: INV_EBI_UTIL.debug_line('STEP 160: SOURCE SYSTEM ID: '|| l_source_system_id);
2540: EXCEPTION
2541: WHEN NO_DATA_FOUND THEN

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