APPS.INVPUOPI dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 816: from mtl_system_items_b_kfv

812: */
813: if (seg1 is null) then
814: select inventory_item_id
815: into item_id_out
816: from mtl_system_items_b_kfv
817: where organization_id = org_id
818: and concatenated_segments = item_number_in;
819: else
820: select inventory_item_id

Line 822: from mtl_system_items_b_kfv

818: and concatenated_segments = item_number_in;
819: else
820: select inventory_item_id
821: into item_id_out
822: from mtl_system_items_b_kfv
823: where segment1 = seg1
824: and organization_id = org_id
825: and concatenated_segments = item_number_in;
826: end if;

Line 831: from mtl_system_items_b_kfv

827: else
828:
829: select inventory_item_id
830: into item_id_out
831: from mtl_system_items_b_kfv
832: where organization_id = org_id
833: and concatenated_segments = item_number_in;
834:
835: end if;

Line 1059: from mtl_system_items_b_kfv

1055:
1056: if (seg1 is null) then
1057: select inventory_item_id
1058: into item_id_out
1059: from mtl_system_items_b_kfv
1060: where concatenated_segments = item_number_in
1061: group by inventory_item_id; -- Bug: 3447718 - added group by to get distinct inventory_item_id
1062: else
1063: select inventory_item_id

Line 1065: from mtl_system_items_b_kfv

1061: group by inventory_item_id; -- Bug: 3447718 - added group by to get distinct inventory_item_id
1062: else
1063: select inventory_item_id
1064: into item_id_out
1065: from mtl_system_items_b_kfv
1066: where segment1 = seg1
1067: and concatenated_segments = item_number_in
1068: group by inventory_item_id; -- Bug: 3447718 - added group by to get distinct inventory_item_id
1069: end if;

Line 1074: from mtl_system_items_b_kfv

1070:
1071: else
1072: select inventory_item_id
1073: into item_id_out
1074: from mtl_system_items_b_kfv
1075: where concatenated_segments = item_number_in
1076: group by inventory_item_id; -- Bug: 3447718 - added group by to get distinct inventory_item_id
1077:
1078: end if;