APPS.INVPUOPI dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 797: from mtl_system_items_b_kfv

793: */
794: if (seg1 is null) then
795: select inventory_item_id
796: into item_id_out
797: from mtl_system_items_b_kfv
798: where organization_id = org_id
799: and concatenated_segments = item_number_in;
800: else
801: select inventory_item_id

Line 803: from mtl_system_items_b_kfv

799: and concatenated_segments = item_number_in;
800: else
801: select inventory_item_id
802: into item_id_out
803: from mtl_system_items_b_kfv
804: where segment1 = seg1
805: and organization_id = org_id
806: and concatenated_segments = item_number_in;
807: end if;

Line 812: from mtl_system_items_b_kfv

808: else
809:
810: select inventory_item_id
811: into item_id_out
812: from mtl_system_items_b_kfv
813: where organization_id = org_id
814: and concatenated_segments = item_number_in;
815:
816: end if;

Line 1040: from mtl_system_items_b_kfv

1036:
1037: if (seg1 is null) then
1038: select inventory_item_id
1039: into item_id_out
1040: from mtl_system_items_b_kfv
1041: where concatenated_segments = item_number_in
1042: group by inventory_item_id; -- Bug: 3447718 - added group by to get distinct inventory_item_id
1043: else
1044: select inventory_item_id

Line 1046: from mtl_system_items_b_kfv

1042: group by inventory_item_id; -- Bug: 3447718 - added group by to get distinct inventory_item_id
1043: else
1044: select inventory_item_id
1045: into item_id_out
1046: from mtl_system_items_b_kfv
1047: where segment1 = seg1
1048: and concatenated_segments = item_number_in
1049: group by inventory_item_id; -- Bug: 3447718 - added group by to get distinct inventory_item_id
1050: end if;

Line 1055: from mtl_system_items_b_kfv

1051:
1052: else
1053: select inventory_item_id
1054: into item_id_out
1055: from mtl_system_items_b_kfv
1056: where concatenated_segments = item_number_in
1057: group by inventory_item_id; -- Bug: 3447718 - added group by to get distinct inventory_item_id
1058:
1059: end if;