APPS.RCV_DEFAULT_PKG dependencies on MTL_ITEM_FLEXFIELDS

Line 879: FROM mtl_item_flexfields

875: END IF;
876:
877: SELECT inventory_item_id
878: INTO x_item_id
879: FROM mtl_item_flexfields
880: WHERE organization_id = p_org_id
881: AND description = p_item_description;
882:
883: RETURN x_item_id;

Line 908: FROM mtl_item_flexfields

904: END IF;
905:
906: SELECT inventory_item_id
907: INTO x_item_id
908: FROM mtl_item_flexfields
909: WHERE organization_id = p_org_id
910: AND item_number = p_item_num;
911:
912: RETURN x_item_id;

Line 939: * mtl_item_flexfields, because mtl_system_items_vl view is based on

935: END IF;
936: /** Bug: 5504176
937: * Item description field is MLS(multi lingual support) complaint field.
938: * So, we have to fetch the description from mtl_system_items_vl instead of
939: * mtl_item_flexfields, because mtl_system_items_vl view is based on
940: * mtl_system_items_tl table.
941: */
942: SELECT description
943: INTO x_item_description

Line 975: FROM mtl_item_flexfields

971: END IF;
972:
973: SELECT item_number
974: INTO x_item_num
975: FROM mtl_item_flexfields
976: WHERE organization_id = p_org_id
977: AND inventory_item_id = p_item_id;
978:
979: RETURN x_item_num;