APPS.INV_EBI_ITEM_HELPER dependencies on MTL_SYSTEM_ITEMS_B

Line 236: FROM mtl_system_items_b_kfv

232: WHEN G_INVENTORY_ITEM THEN
233: l_pk1 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);
234: l_pk2 := ID_COL_VALUE('inventory_item_id',p_pk_col_name_val_pairs);
235: SELECT concatenated_segments INTO l_code
236: FROM mtl_system_items_b_kfv
237: WHERE organization_id = l_pk1
238: AND inventory_item_id = l_pk2;
239: END CASE;
240: END IF;

Line 3333: FROM mtl_system_items_b

3329: p_organization_id IS NOT NULL AND
3330: p_item_classification_id IS NOT NULL) THEN
3331:
3332: SELECT COUNT(1) INTO l_count
3333: FROM mtl_system_items_b
3334: WHERE
3335: inventory_item_id = p_inventory_item_id AND
3336: organization_id = p_organization_id AND
3337: item_catalog_group_id = p_item_classification_id;

Line 4262: FROM mtl_system_items_b

4258: ,l_item_custom_obj.GLOBAL_ATTRIBUTE7
4259: ,l_item_custom_obj.GLOBAL_ATTRIBUTE8
4260: ,l_item_custom_obj.GLOBAL_ATTRIBUTE9
4261: ,l_item_custom_obj.GLOBAL_ATTRIBUTE10
4262: FROM mtl_system_items_b
4263: WHERE inventory_item_id=l_item_id AND organization_id=l_org_id;
4264:
4265: IF ( (l_item_core_obj.revision_id IS NULL OR l_item_core_obj.revision_id= fnd_api.g_miss_num)
4266: AND (l_org_id IS NOT NULL AND l_item_id IS NOT NULL)

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